Navision CommercePortal Error ( on W2003 Server )

Comments

• mcoAggie Member Posts: 23

  2005-07-29

  Did you change the global.asa file to work with the Windows 2K3?
  
  There is one specific line that must be changed. It relates to the ADO connection string. The pup for the CP site will not work until this line is changed. My NSC told me the line to change but I cannot remember which specific line. Try line 433 (word wrap on), 423 (word wrap off)
  I think we changed the ADODB connection but I am not 100%.
  Set oGetOpenConnectionObject = Server.CreateObject("ADODB.Connection")
  
  
  The below link may help you but it is not what we changed.
  http://www.mbsonline.org/forum/topic.as ... global.asa
  
  Also I would advise you to use the quick unpack in CS2K2 instead of the advanced. It's easier to setup this way. Also remember to use SQL authentication for all connection strings.

  Owen McDonald
  http://www.archerpoint.com

  0
• mcoAggie Member Posts: 23

  2005-07-29

  Oh.. just noticed you are in Bucharest. We have an office we brought onto Navision this past Feburary and just finished with the RON conversion. Do you work for the NSC called EstWest?

  Owen McDonald
  http://www.archerpoint.com

  0
• Kiwi Member Posts: 5

  2005-07-29

  Hi mcoAggie ,
  
  thanks for your reply .
  
  but i did all you mentioned.
  
  1) yes i did change the global.asa so it works only with the ADO.Component
  i have on my PC .
  
  I think in the original global.asa was ADO 2.5 , when i have only :
  ADO
  ADO 2.8
  and
  ADO 2.80
  
  2) i did change the SQL auth for all connection strings ...
  
  To your question "Do you work for the NSC called EstWest?" the answer is "No".
  Yes RON conversion it's an issue here these days but none of my interest
  for the moment
  
  If you have any other ideas that can fix my problem , i will really appreciate ...
  
  Best Regards ,
  Kiwi

  0
• mcoAggie Member Posts: 23

  2005-07-29

  Hi Kiwi:
  
  :-# EstWest is the only NSC I know in Bucharest.
  
  All I can tell you are some of the basics and maybe it will help. I am new to Commerce Portal also, but have been installing, re-installing it on 2K3 now for about a month. I suppose you are not using the RO Localized version as I did not think it had CP support.
  
  Did you check that the csapp.ini has the correct value for your iis site?
  Are all the services running? MSMQ, NAS, Nav-DB, SQL, SQL OLAP, etc..
  
  Have you synchronized the site yet and did it work fine? If you change a value in Navision (for example .. currency table) is it synching to SQL?
  
  Does the Commerce_Website table exist in SQL with the correct value?
  
  In IIS/Web Service Extensions are ASP pages allowed?
  
  Just some random ideas.

  Owen McDonald
  http://www.archerpoint.com

  0
• mandyk Member Posts: 57

  2005-07-31

  Hi Kiwi:
  
  Please check if you can find a table named "COMMERCE_WEBSITE" in your commerce portal database in MS. SQL. This table should be there after you do full synchronization from Navision commerce portal, but from the error it seem you don't have it. Apart from above table, you must able to see some other tables in SQL server such COMMERCE_SALESHEADER, COMMERCE_CURRENCY, etc.
  
  If you don't see them, means your XML synchronization stuck in one of many conditions. It could be went to errmq label in MSMQ component at the web servers due connection string issue, could be CPSYNCH service didn't started yet, so it's stuck in synchmq MSMQ label, or you don't have any NAS that pull out the data from Navision queue table and transform them into XML and dispacth to synchmq MSMQ label.
  
  hope that explaination can little bit help you out. :?:

  0
• Kiwi Member Posts: 5

  2005-08-01

  Hi guys ,
  
  thank you for replies , i will look into it ...
  
  i saw on my MS-SQL i have no COMMERCE_WEBSITE , so synch wasn't working ...
  
  i am on it ...
  i will let you know ...
  
  Thank you ,
  Kiwi

  0
• Kiwi Member Posts: 5

  2005-08-04

  Hi mandyk ,
  Hi mcoAggie ,
  
  thanks guys for your INPUT =D>
  
  I am not much of a Sys Admin as i thought this is always simple stuff and the Devel is the right business ...
  
  I must confense to you here i did change my opinion about this ( not too much though ) .
  
  Eventually i had it set up for any type of versions.
  
  Thanks again guys,
  Kiwi

  0