Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 300 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
UserObject not synching with contact
nbrown
Member Posts: 2
Hi all,
In the commerce portal installation at a client site, the SQL CommercePortal_commerce database table 'userobject' contains no rows. I know that synchronization is working fine between the back-end and the front-end because the CONTACT table in Navision is being synched ok and I can see the changes that have been made in the COMMERCE_CONTACT table.
We have a test system that replicates our clients and the 'userobject' SQL table on our installation is being updated ok when a new Contact is either inserted or updated from Navision and we can login to the test site ok and everything is fine.
Any advice would be most grateful as no users can login to the web site.
To my knowledge there is no difference in the installation of the client site and my test site. I am only using CP for user logins and message queueing and only the contact table needs to be synched.
Thanks,
Neil
In the commerce portal installation at a client site, the SQL CommercePortal_commerce database table 'userobject' contains no rows. I know that synchronization is working fine between the back-end and the front-end because the CONTACT table in Navision is being synched ok and I can see the changes that have been made in the COMMERCE_CONTACT table.
We have a test system that replicates our clients and the 'userobject' SQL table on our installation is being updated ok when a new Contact is either inserted or updated from Navision and we can login to the test site ok and everything is fine.
Any advice would be most grateful as no users can login to the web site.
To my knowledge there is no difference in the installation of the client site and my test site. I am only using CP for user logins and message queueing and only the contact table needs to be synched.
Thanks,
Neil
0
Comments
some questions from my site:
a.) Did you modify/add any custom columns for synchronisation?
b.) If yes, did you export the script of the userobject table during packing of the commerce site?
c.) Do the contacts have Commerce Portal logins (because only these contacts are synchronized to the userobject table)?
d.) Did you change anything in the table name? Because the synch service is identifying the userobjects table by the name COMMERCE_USER
Thanks a lot
Rainer