Commerce Portal 3.70 - Error Syncronizing Item Table

emabare
emabare Member Posts: 8
edited 2004-07-12 in Navision e-Commerce
Hi All,
I have this problem concerning Commerce Portal 3.70...

Scenario:
- first server: Nas+Navi SQL Server
- second server: CommerceServer 2002
- Navi Version: 3.70 ITA

The syncro process seems to work fine less than item teble syncronization.
The syncro of this table create errors (two for each item records) in errormsg queue with this content:
Error No. 2003304437
Desc: The definition you specified does not exist
Source: Commerce Catalog Manager

In CommercePortal_commerce DB i never see the table COMMERCE_ITEM created after the syncro. Tried to send only the CREATETABLE message, the result is: no error in errormsg queue but no table in CommercePortal_commerce DB

Sending the same createtable message with tablename VISION instead of COMMERCE_ITEM work fine. After that I can rename VISION table in COMMERCE_ITEM directly in SQL enterprise manager with no problem. Sending now only the INSERT queues i have the same errors in errormsg queue.

original CREATE TABLE message:

<SYNCHRONIZATION>
<PROCESS_TYPE>SYNCHRONIZATION </PROCESS_TYPE>
<DS>RADWEB2004 </DS>
<IC>CommercePortal_commerce </IC>
<UID>sa </UID>
<COMMAND>CREATETABLE </COMMAND>
<PRIMARYKEY>NO</PRIMARYKEY>
<TABLE>COMMERCE_ITEM</TABLE>
<VALUES.BLOCKED>VARCHAR(4) NULL</VALUES.BLOCKED>
<VALUES.CLASS>VARCHAR(10) NULL</VALUES.CLASS>
<VALUES.DESCRIPTION>VARCHAR(30) NULL</VALUES.DESCRIPTION>
<VALUES.DESCRIPTION2>VARCHAR(30) NULL</VALUES.DESCRIPTION2>
<VALUES.LASTDATEMODIFIED>DATETIME NULL</VALUES.LASTDATEMODIFIED>
<VALUES.NO>VARCHAR(20) NOT NULL</VALUES.NO>
<VALUES.PICTUREFILENAME>VARCHAR(20) NULL</VALUES.PICTUREFILENAME>
<VALUES.STATISTICSGROUP>INT NULL</VALUES.STATISTICSGROUP>
<VALUES.UNITCOST>DECIMAL(38,20) NULL</VALUES.UNITCOST>
<VALUES.UNITPRICE>DECIMAL(38,20) NULL</VALUES.UNITPRICE>
</SYNCHRONIZATION>


INSERT TABLE (One record) MESSAGE:

<SYNCHRONIZATION>
<PROCESS_TYPE>SYNCHRONIZATION </PROCESS_TYPE>
<DS>RADWEB2004 </DS>
<IC>CommercePortal_commerce </IC>
<UID>sa </UID>
<COMMAND>INSERT </COMMAND>
<TABLE>COMMERCE_ITEM</TABLE>
<VALUES.BLOCKED>0</VALUES.BLOCKED>
<VALUES.CLASS>ALTRO</VALUES.CLASS>
<VALUES.DESCRIPTION>Bicicletta</VALUES.DESCRIPTION>
<VALUES.DESCRIPTION2></VALUES.DESCRIPTION2>
<VALUES.LASTDATEMODIFIED>20030715</VALUES.LASTDATEMODIFIED>
<VALUES.NO>1000</VALUES.NO>
<VALUES.STATISTICSGROUP>0</VALUES.STATISTICSGROUP>
<VALUES.UNITCOST>350,595</VALUES.UNITCOST>
<VALUES.UNITPRICE>4000</VALUES.UNITPRICE>
</SYNCHRONIZATION>


Have you ideas?!?

Comments

  • IHateLinux
    IHateLinux Member Posts: 223
    Hi,

    you will never find a table named COMMERCE_ITEM.
    During the synch, the synch service gets the message out of the queue. The table name COMMERCE_ITEM is for the service the "hard coded" information, that the sql statement in the message belongs to an item. The service then creates some commerce server objects and they are in the different catalog tables.

    For the error you got:
    Please have a look in the bizdesk of the portal and see if the catalog definitions are loaded. If you have added a field in the synch, then you have to modify the item and class definition in bizdesk too.

    If you have any further questions feel free to ask them here.

    HTH,

    IHateLinux
  • emabare
    emabare Member Posts: 8
    Thank's, I have already solved my problem... the problem was with the italian version :?. I used the items.stx W1 file and the catalog work fine.

    Emanuele

Categories