Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Copper Contributor
Posts: 36
Registered: ‎01-13-2011

Re: SLX Conversion Utility Error

Sorry for the delay. Just for the record, I implemented/deployed the web client this time and i still got the same errors.

 

"Saleslogix v8.0x to v8.1 Upgrade" "8.1.0" "12/19/2013 2:18 AM" "Saleslogix v8.0 to v8.1 Upgrade" is the bundle installed. This is an 8.0 database.

 

Here are the Query Results;

 

TABLENAME

FIELDNAME

FIELDOFFSET

FIELDINDEX

SEQCODE

KEYFLAG

SYNC

USERDEF

DISPLAYNAME

ISHIDDEN

DATETIMETYPE

DESCRIPTION

AUTOINCREMENT

MODIFYDATE

MODIFYUSER

CREATEDATE

CREATEUSER

SYNCDIGEST

APPID

0

3805

2

0

Y

F

APPID

F

NULL

The APPID from the mapping table

F

11/29/12 7:21 AM

ADMIN      

11/29/12 7:21 AM

ADMIN      

SYNCDIGEST

CONFLICTPRIORITY

0

3808

2

0

Y

F

ConflictPriority

F

NULL

Priority used when resolving conflicts

F

11/29/12 7:21 AM

ADMIN      

11/29/12 7:21 AM

ADMIN      

SYNCDIGEST

CREATEDATE

0

3802

2

0

Y

F

Createdate

F

U

NULL

F

11/29/12 7:21 AM

ADMIN      

11/29/12 7:21 AM

ADMIN       

SYNCDIGEST

CREATEUSER

0

3801

2

0

Y

F

Createuser

F

NULL

NULL

F

11/29/12 7:21 AM

ADMIN      

11/29/12 7:21 AM

ADMIN      

SYNCDIGEST

LASTUPDATED

0

3807

2

0

Y

F

LastUpdated

F

U

NULL

F

11/29/12 7:21 AM

ADMIN      

11/29/12 7:21 AM

ADMIN      

SYNCDIGEST

MODIFYDATE

0

3804

2

0

Y

F

Modifydate

F

U

NULL

F

11/29/12 7:21 AM

ADMIN      

11/29/12 7:21 AM

ADMIN      

SYNCDIGEST

MODIFYUSER

0

3803

2

0

Y

F

Modifyuser

F

NULL

NULL

F

11/29/12 7:21 AM

ADMIN      

11/29/12 7:21 AM

ADMIN      

SYNCDIGEST

RESOURCETYPE

0

3809

2

0

Y

F

ResourceType

F

NULL

The resource (ie. Account) this vector clock is for.

F

11/29/12 7:21 AM

ADMIN      

11/29/12 7:21 AM

ADMIN      

SYNCDIGEST

SYNCDIGESTID

0

3800

2

0

Y

F

Syncdigestid

F

NULL

NULL

T

11/29/12 7:21 AM

ADMIN      

11/29/12 7:21 AM

ADMIN      

SYNCDIGEST

TICK

0

3806

2

0

Y

F

Tick

F

NULL

Holds the current vector clock tick

F

11/29/12 7:21 AM

ADMIN      

11/29/12 7:21 AM

ADMIN      

 

APPID

NAME

ENDPOINTURL

USERNAME

PWD

CREATEUSER

CREATEDATE

MODIFYUSER

MODIFYDATE

ENABLED

RESTRICTTOSINGLEACCOUNT

ERPMANAGESSO

SYNCINTERVAL

ENABLEEMAILAUTH

ISSYSTEMENDPOINT

INTEGRATIONID

ISUSERENDPOINT

OAUTHPROVIDERID

USERID

Q6UJ9A00040B

NULL

NULL

NULL

NULL

ADMIN      

12/20/12 9:05 PM

ADMIN      

4/11/14 2:45 PM

T

NULL

NULL

NULL

F

T

NULL

F

NULL

NULL

 

Steve Meyers
Lead Software Developer, Business Software Applications
Promega Corporation
2800 Woods Hollow Rd
Madison, WI 53711-5399
steve.meyers@promega.com
www.promega.com
Copper Contributor
Posts: 9
Registered: ‎02-04-2014

Re: SLX Conversion Utility Error

Steve,

 

The results from the queries looks to be in order.  To ensure that your db is setup correctly and the provider is working as expected we would like for you to run the following sql insert statement from ADO Explorer or from SLX Admin/Execute SQL.  Please let us know the results.

 

INSERT INTO SYSDBA.SYNCDIGEST (APPID,

RESOURCETYPE) VALUES ('XXXXXXXXXXXX','TEST')

 

Thanks

Copper Contributor
Posts: 36
Registered: ‎01-13-2011

Re: SLX Conversion Utility Error

The insert failed.

Steve Meyers
Lead Software Developer, Business Software Applications
Promega Corporation
2800 Woods Hollow Rd
Madison, WI 53711-5399
steve.meyers@promega.com
www.promega.com
Employee
Posts: 79
Registered: ‎06-25-2009

Re: SLX Conversion Utility Error

Steve, could you also please run the query below and post the results.

 

 

SELECT SITECODE

,KEYTYPE

,KEYVALUE

,KEYDESC

,MODIFYDATE

,MODIFYUSER

,CREATEDATE

,CREATEUSER

FROM sysdba.SITEKEYS where KEYTYPE = 25 and SITECODE =(select SITECODE from sysdba.SYSTEMINFO)

 


Thanks

Paul Zeimet
Development Manager
Infor CRM
Copper Contributor
Posts: 36
Registered: ‎01-13-2011

Re: SLX Conversion Utility Error

[ Edited ]
SITECODE KEYTYPE KEYVALUE KEYDESC MODIFYDATE MODIFYUSER CREATEDATE CREATEUSER
AAAA         25 A00009E Other 4/11/14 2:46 PM ADMIN        5/14/01 12:00 PM ADMIN       
Steve Meyers
Lead Software Developer, Business Software Applications
Promega Corporation
2800 Woods Hollow Rd
Madison, WI 53711-5399
steve.meyers@promega.com
www.promega.com
Copper Contributor
Posts: 9
Registered: ‎02-04-2014

Re: SLX Conversion Utility Error

Steve,

 

Can you tell you post the results of this query:

 

select * from resynctabledefs where tablename = 'syncdigest'

 

Copper Contributor
Posts: 36
Registered: ‎01-13-2011

Re: SLX Conversion Utility Error

There are no records returned.

Steve Meyers
Lead Software Developer, Business Software Applications
Promega Corporation
2800 Woods Hollow Rd
Madison, WI 53711-5399
steve.meyers@promega.com
www.promega.com
Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: SLX Conversion Utility Error

Did same to an 8.1 eval - results returned:

        SUNCDIGEST SYNCDIGESTID NULL MODIFYDATE F T SyncDigest NULL NULL NULL 2012-11-29 07:21:58.000 ADMIN ......

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Copper Contributor
Posts: 36
Registered: ‎01-13-2011

Re: SLX Conversion Utility Error

This database was created from a blank unicode SalesLogix 8.0 database.

Steve Meyers
Lead Software Developer, Business Software Applications
Promega Corporation
2800 Woods Hollow Rd
Madison, WI 53711-5399
steve.meyers@promega.com
www.promega.com
Copper Contributor
Posts: 36
Registered: ‎01-13-2011

Re: SLX Conversion Utility Error

[ Edited ]

The following entries were missing, I have added them to the table;

ACCOUNTOPERATINGCOMP
APPIDMAPPING
COMMODITYGROUP
COUNTRYCODEMAPPING
DEDUPJOB
DEDUPRESULT
ERPEMAILADDRESS
ERPPHONENUMBER
ERPSALESORDER
ERPTRADINGACCOUNT
QRTZ_BLOB_TRIGGERS
QRTZ_CALENDARS
QRTZ_CRON_TRIGGERS
QRTZ_FIRED_TRIGGERS
QRTZ_JOB_DETAILS
QRTZ_LOCKS
QRTZ_PAUSED_TRIGGER_GRPS
QRTZ_SCHEDULER_STATE
QRTZ_SIMPLE_TRIGGERS
QRTZ_SIMPROP_TRIGGERS
QRTZ_TRIGGERS
REMOTEAUTOCLEANUP
SLXCONTRACTSYNCLOG
SLXLOCATION
SLXLOGITEM
SLXPRICE
SLXPRICELIST
SYNCDIGEST
SYNCJOB
UNITOFMEASURE

Steve Meyers
Lead Software Developer, Business Software Applications
Promega Corporation
2800 Woods Hollow Rd
Madison, WI 53711-5399
steve.meyers@promega.com
www.promega.com