Error: Method "CE_LinkManufacturer" failed

Hi

CE_LinkManufacturer is a method and not a table in SQL db. Corresponding database table are CE_CLOUDMANUFACTURER. This is error is so generic. It denotes query return multiple records and method expecting one item. Can you please debug this method CE_LinkManufacturer and check ?

Thank You

Gopikrishnan R

Hi,

I remember that I also got a "Not a single item" error while doing something similar during my first CE tests. 

In my case I had an Manufacturer with an outdated lifecycle. The corresponding items a state that wasn´t present in the latest lifecycle anymore. Do you have ever changed the lifecycle of your Manufacturer? If yes, you have to check if all your Manufacturer still use the correct lifecycle. 

But beware on any debugging you do here! I was debugging the error by myself as I didn´t got any response from Aras support. After I proudly found the missing piece, I got a phone call from a not amused Aras product manager a few minutes later as I accidentally created a lot of requests to the IHS database.

Hi AngelaIp,
Hi Gopikrishnan,

Thank you for your advice.

I'll check and try to Manufacturer first.

Maybe the solution is more simple. In your screenshot you tried to start the sync from a new created part. Do you get the same error message when you try to sync an existing part?

Hi AngelaIp,　

Hi Gopikrishnan,

I tried the case which your advice.

1.If I try to make a new parts, disable to add the data without choosing the manufacturer of pull down menu.

2. I found some warning in method  CE_LinkManufacturer source.

I'll upload source code of CE_LinkManufacturer  next reply

I found warning mark Line 77,88 and 123.

looks these line grammar is incorrect.. but I'm not professional of Java script.

I'm checking them now.

--------------------<below is CE_LinkManufacturer  code>---------

//Get settings for 'Manufacturer'
var formattedSettingsItm = new Item('ItemType', 'CE_GetFormattedSettings');
formattedSettingsItm.setProperty('cloud_itemtype', 'Manufacturer');
formattedSettingsItm = formattedSettingsItm.apply();

if (formattedSettingsItm.isError())
{
top.aras.AlertError('Unable to get formatted settings for "Manufacturer" cloud type: ' + formattedSettingsItm.getErrorString());
return;
}

var propertyMappingItm = formattedSettingsItm.getItemsByXPath('Relationships/Item[@type="Property Mapping"]');

var manufacturerItemTypeName = formattedSettingsItm.getPropertyAttribute('local_itemtype', 'name');
var manufacturerCeObjectIdPropertyName = propertyMappingItm.getPropertyAttribute('ce_object_id', 'name');
var manufacturerCeSourcePropertyName = propertyMappingItm.getPropertyAttribute('ce_source', 'name');
var manufacturerCeSyncDatePropertyName = propertyMappingItm.getPropertyAttribute('ce_sync_date', 'name');
var manufacturerManufacturerNamePropertyName = propertyMappingItm.getPropertyAttribute('mfr_name_1', 'name');
var manufacturerCeManufacturerNamePropertyName = propertyMappingItm.getPropertyAttribute('mfr_name_2', 'name');

var isMainGrid = (typeof(parent.itemTypeName) === 'undefined');
var aWindow = top.aras.getMostTopWindowWithAras(window);

if (aras.commonProperties && aras.commonProperties.SearchCountModeException) {
aras.commonProperties.SearchCountModeException.push('03278E95AFE34B7EA0B352EAA85AE021');
}
var args = {
aras: aras,
type: 'SearchDialog',
dialogWidth: 700,
dialogHeight: 450,
itemtypeName: 'CE_CloudManufacturer'
};
var dialog = (aWindow.main || aWindow).ArasModules.MaximazableDialog.show('iframe', args);
dialog.promise.then(callback);

//Add 'gridLinkClick' event handler
var intervalId = setInterval(function() {
try
{
var contentWindow = dialog.dialogNode.childNodes[1].childNodes[0].contentWindow;
var grid = contentWindow.grid || contentWindow.gridApplet;

if ((typeof(grid) !== 'undefined') && (grid !== null))
{
clearInterval(intervalId);
dojo.connect(grid, 'gridLinkClick', onGridLinkClickEventHandler);
}
}
catch(e)
{
}
}, 300);

function callback(res)
{
if (aras.commonProperties && aras.commonProperties.SearchCountModeException) {
aras.commonProperties.SearchCountModeException.pop();
}
if (isNullOrUndefined(res)) {
return;
}
var item = res.item;
if (!isNullOrUndefined(item))
{
//Get item from cache or from server
var manufacturerId = aras.getVariable('CE_CurrentItemId', '');
var manufacturerItm = aras.getItemById(manufacturerItemTypeName, manufacturerId, 0);

if (!isNullOrUndefined(manufacturerItm))
{
var objectId = top.aras.getItemProperty(manufacturerItm, manufacturerCeObjectIdPropertyName, '');

if (objectId !== '')
{
var res = top.aras.confirm(manufacturerItemTypeName + ' is already linked. Are you sure you want to overwrite the link?');
if (!res) {
return;
}
}

var localManufacturerName = top.aras.getItemProperty(manufacturerItm, manufacturerManufacturerNamePropertyName, '');
var cloudManufacturerObjectId = top.aras.getItemProperty(item, 'mfr_object_id', '');
var cloudManufacturerName = top.aras.getItemProperty(item, 'mfr_name', '');
var cloudCeSource = '1';

top.aras.setItemProperty(manufacturerItm, manufacturerCeObjectIdPropertyName, cloudManufacturerObjectId);
if (localManufacturerName == '')
{
top.aras.setItemProperty(manufacturerItm, manufacturerManufacturerNamePropertyName, cloudManufacturerName);
}
top.aras.setItemProperty(manufacturerItm, manufacturerCeManufacturerNamePropertyName, cloudManufacturerName);
top.aras.setItemProperty(manufacturerItm, manufacturerCeSourcePropertyName, cloudCeSource);
top.aras.setItemProperty(manufacturerItm, manufacturerCeSyncDatePropertyName, '');

if (!isMainGrid)
{
//Update form
aras.RefillWindow(parent.item, parent, true);
} else {
//Update MainGrid
aWindow.main.work.searchContainer.runSearch();
}
}
}
}

function onGridLinkClickEventHandler(str)
{
try
{
var link = (str.split(',')[1]).replace(/'/g, '');
window.open(link, '_blank');
}
catch(e)
{
return;
}
}

function isNullOrUndefined(param)
{
return ((typeof(param) === 'undefined') || (param == null));
}

Hi!

Below is result Debug Link Manufacturer

Checking syntax...

ERROR: 45AFF9E39A6A41E58F80DFA14402C476.
Line number 2, Error Number: CS1012, Too many characters in character literal
Line number 2, Error Number: CS1012, Too many characters in character literal
Line number 3, Error Number: CS1012, Too many characters in character literal
Line number 3, Error Number: CS1012, Too many characters in character literal
Line number 8, Error Number: CS1012, Too many characters in character literal
Line number 12, Error Number: CS1012, Too many characters in character literal
Line number 14, Error Number: CS1012, Too many characters in character literal
Line number 14, Error Number: CS1012, Too many characters in character literal
Line number 15, Error Number: CS1012, Too many characters in character literal
Line number 15, Error Number: CS1012, Too many characters in character literal
Line number 16, Error Number: CS1012, Too many characters in character literal
Line number 16, Error Number: CS1012, Too many characters in character literal
Line number 17, Error Number: CS1012, Too many characters in character literal
Line number 17, Error Number: CS1012, Too many characters in character literal
Line number 18, Error Number: CS1012, Too many characters in character literal
Line number 18, Error Number: CS1012, Too many characters in character literal
Line number 19, Error Number: CS1012, Too many characters in character literal
Line number 19, Error Number: CS1012, Too many characters in character literal
Line number 21, Error Number: CS1525, Invalid expression term '='
Line number 21, Error Number: CS1012, Too many characters in character literal
Line number 25, Error Number: CS1012, Too many characters in character literal
Line number 28, Error Number: CS1513, } expected
Line number 28, Error Number: CS1002, ; expected
Line number 28, Error Number: CS1002, ; expected
Line number 28, Error Number: CS1513, } expected
Line number 29, Error Number: CS1012, Too many characters in character literal
Line number 29, Error Number: CS1002, ; expected
Line number 29, Error Number: CS1513, } expected
Line number 30, Error Number: CS1002, ; expected
Line number 30, Error Number: CS1513, } expected
Line number 31, Error Number: CS1002, ; expected
Line number 31, Error Number: CS1513, } expected
Line number 32, Error Number: CS1012, Too many characters in character literal
Line number 32, Error Number: CS1002, ; expected
Line number 33, Error Number: CS1597, Semicolon after method or accessor block is not valid
Line number 34, Error Number: CS1012, Too many characters in character literal
Line number 35, Error Number: CS1519, Invalid token '(' in class, struct, or interface member declaration
Line number 35, Error Number: CS8124, Tuple must contain at least two elements.
Line number 35, Error Number: CS1519, Invalid token ';' in class, struct, or interface member declaration
Line number 38, Error Number: CS1003, Syntax error, ',' expected
Line number 40, Error Number: CS1003, Syntax error, ',' expected
Line number 41, Error Number: CS1003, Syntax error, ',' expected
Line number 41, Error Number: CS1026, ) expected
Line number 44, Error Number: CS1519, Invalid token 'if' in class, struct, or interface member declaration
Line number 44, Error Number: CS1031, Type expected
Line number 44, Error Number: CS8124, Tuple must contain at least two elements.
Line number 44, Error Number: CS1026, ) expected
Line number 44, Error Number: CS1519, Invalid token 'typeof' in class, struct, or interface member declaration
Line number 44, Error Number: CS8124, Tuple must contain at least two elements.
Line number 44, Error Number: CS1519, Invalid token '!=' in class, struct, or interface member declaration
Line number 44, Error Number: CS1012, Too many characters in character literal
Line number 44, Error Number: CS8124, Tuple must contain at least two elements.
Line number 44, Error Number: CS1026, ) expected
Line number 44, Error Number: CS1519, Invalid token '!=' in class, struct, or interface member declaration
Line number 46, Error Number: CS1001, Identifier expected
Line number 47, Error Number: CS1519, Invalid token '(' in class, struct, or interface member declaration
Line number 47, Error Number: CS1031, Type expected
Line number 47, Error Number: CS1026, ) expected
Line number 47, Error Number: CS1012, Too many characters in character literal
Line number 47, Error Number: CS1519, Invalid token ''gridLinkClick'' in class, struct, or interface member declaration
Line number 47, Error Number: CS1519, Invalid token ')' in class, struct, or interface member declaration
Line number 50, Error Number: CS1022, Type or namespace definition, or end-of-file expected
Line number 50, Error Number: CS8124, Tuple must contain at least two elements.
Line number 51, Error Number: CS1022, Type or namespace definition, or end-of-file expected
Line number 52, Error Number: CS1022, Type or namespace definition, or end-of-file expected
Line number 53, Error Number: CS1022, Type or namespace definition, or end-of-file expected
Line number 53, Error Number: CS1022, Type or namespace definition, or end-of-file expected
Line number 55, Error Number: CS1001, Identifier expected
Line number 67, Error Number: CS1012, Too many characters in character literal
Line number 67, Error Number: CS1011, Empty character literal
Line number 72, Error Number: CS1011, Empty character literal
Line number 74, Error Number: CS1525, Invalid expression term '='
Line number 74, Error Number: CS1011, Empty character literal
Line number 76, Error Number: CS1012, Too many characters in character literal
Line number 82, Error Number: CS1011, Empty character literal
Line number 83, Error Number: CS1012, Too many characters in character literal
Line number 83, Error Number: CS1011, Empty character literal
Line number 84, Error Number: CS1012, Too many characters in character literal
Line number 84, Error Number: CS1011, Empty character literal
Line number 88, Error Number: CS1525, Invalid expression term '='
Line number 88, Error Number: CS1011, Empty character literal
Line number 94, Error Number: CS1011, Empty character literal
Line number 108, Error Number: CS1001, Identifier expected
Line number 112, Error Number: CS1525, Invalid expression term '/'
Line number 112, Error Number: CS1012, Too many characters in character literal
Line number 112, Error Number: CS1003, Syntax error, ',' expected
Line number 112, Error Number: CS1010, Newline in constant
Line number 112, Error Number: CS1012, Too many characters in character literal
Line number 112, Error Number: CS1003, Syntax error, ',' expected
Line number 113, Error Number: CS1012, Too many characters in character literal
Line number 113, Error Number: CS1026, ) expected
Line number 121, Error Number: CS1001, Identifier expected
Line number 123, Error Number: CS1525, Invalid expression term '='
Line number 123, Error Number: CS1012, Too many characters in character literal
Line number 123, Error Number: CS1525, Invalid expression term '='
Line number 125, Error Number: CS1022, Type or namespace definition, or end-of-file expected
Line number 126, Error Number: CS1022, Type or namespace definition, or end-of-file expected
Line number 162, Error Number: CS1022, Type or namespace definition, or end-of-file expected

When I executed this method, error is detected as below.

Message is indicated This method type(Javascrip) is not supported.

<SOAP-ENV:Envelope xmlns:SOAP-ENV="">schemas.xmlsoap.org/.../"><SOAP-ENV:Body><SOAP-ENV:Fault xmlns:af="">www.aras.com/.../faultcode><faultstring><![CDATA[ CE_LinkManufacturer に設定しているメソッドタイプ (JavaScript) は現在サポートされていません。]]></faultstring><detail><af:legacy_detail><![CDATA[ CE_LinkManufacturer に設定しているメソッドタイプ (JavaScript) は現在サポートされていません。]]></af:legacy_detail></detail></SOAP-ENV:Fault></SOAP-ENV:Body></SOAP-ENV:Envelope> 

Hi,

sorry I somehow lost track of this thread. What do you currently try to achieve? Where you able to link your Manufacturer? Maybe you could provide some steps to reproduce.
You shouldn´t need to customize the CE_LinkManufacturer Method. Do you have already asked Aras support about this issue?

Be really careful about any changes you do in CE! The CE code is insufficiently secured and mistakes can happen too easy. Unfortunately, Aras did not spend any energy so far to make the code more fail save. Be careful not to end up as a scapegoat for their development fails!

Hi AngelaIp,

Thank you for your advice.

fortunately I've just checked  CE_LinkManufacturer Method only, I don't change any parameter.

Regarding the manufacturer record, I cannot add  Manufacturer name in other menu.

And Manufacturer name looks link to the cloud Manufacturer... ?

But I'm not sure I cannot access Cloud Manufacturer from sourcing menu.

Anyway, error dialog is indicated client side error.

It's very curious I can find unknown CE manufacturer name from inquiry dialog.

But that manufacturer name is invalid data . because I could not add it before.

I don't know why invalid data is existed in the inquiry.

I'm thinking whether should re-install aras innovator and SQL server.

Best Regards!