Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 266 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 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
Options
HELP...Syncronisation with the SQL Server
patcc
Member Posts: 4
Hi and Happy New Year,
I have installed commerce portal and my problem is as follows:
Why after synchronisation of the commerce portal, I don't get the table ncpcatalog_catalogproduct on the SQL server. But I get the other tables like commerce_<table name> and UserObjects.
I can't find any problem in the installation.
I have also tried to synchronise by using the codeunit 6205. but still we do not have the table ncpcatalog_catalogproduct. We have also re-unpack the pup package and perform another synchronisation thru the codeunit but in vain.
Also we have tried to open the commerce portal thru the browser and we get the following error message.
Technical Information (for support personnel)
Error Type:
Commerce.AuthManager.1 (0x80070057)
AuthManager(CommerceServer): You should call 'AuthManager::Initialize()' method with a valid site-name, before calling any other AuthManager API.
/CommercePortal/global.asa, line 77
Can anyone help me solve this problem??
Thanks
I have installed commerce portal and my problem is as follows:
Why after synchronisation of the commerce portal, I don't get the table ncpcatalog_catalogproduct on the SQL server. But I get the other tables like commerce_<table name> and UserObjects.
I can't find any problem in the installation.
I have also tried to synchronise by using the codeunit 6205. but still we do not have the table ncpcatalog_catalogproduct. We have also re-unpack the pup package and perform another synchronisation thru the codeunit but in vain.
Also we have tried to open the commerce portal thru the browser and we get the following error message.
Technical Information (for support personnel)
Error Type:
Commerce.AuthManager.1 (0x80070057)
AuthManager(CommerceServer): You should call 'AuthManager::Initialize()' method with a valid site-name, before calling any other AuthManager API.
/CommercePortal/global.asa, line 77
Can anyone help me solve this problem??
Thanks
0
Comments
Sounds like you have two separate problems:
1) Item data from Navision isn't going into the catalog table in Commerce Server.
This is probably because you have classified your items in Navision but not created matching classes in BizDesk in Commerce Server. How to do this is explained in chapter 4 of the CP training manual. Nowhere is the siginificance of it explained.
2) AuthManager error.
Check the "CRK Common Errors CP" file in the Channel Readiness Kit for e-Comm.
Have fun!
The most reason why your product catalog table didn't created because NFitem catalog schema isn't configured properly during unpacking the PUP. Make sure you have NFitem catalog schema in bizdesk and try to force synch the item table.
Your second error is the most common error whenever I installed CP.
1. try to restart your IIS. the most reason is because IIS application
setting variables isn't populated completely during installation.
The other way to force the IIS to reload commerce portal application
variables is to re-save the global.asa and try to open the url again.
2. switch the error level to development so you will get a bit detail
error. This error control you can find it in global.asa
have fun
Andy K.
Where is a bug in global.asa. When you install you site to a site other then "default website" you will get this error.
Resolution:
Change the following row in global.asa
strSitePath = Server.MapPath(WEBSITE_ROOT_DIRECTORY)& "\" & MSCSCommerceSiteName
to this
strSitePath = Server.MapPath(WEBSITE_ROOT_DIRECTORY)& "\CommercePortal"
the line above only works if you have unpuped your site in the default path "sitename/commerceportal".
Dont worry about the "ncpcatalog_catalogproduct" table where should not be one.