mibuso.com
Home› Navision e-Commerce
Options

Navision CommercePortal Error ( on W2003 Server )

KiwiKiwi Member Posts: 5
edited 2005-08-04 in Navision e-Commerce
Hi guys ,

I am trying to get the Navision Commerce Portal in action :

W2003 Server
SQL 2000
Navision 4 ( db Server , Client , Server )
Commerce Server 2002
Commerce Web Portal from Navision 3.7 CD

I did install ALL accordingly to the documentations in the proper order and follow strictly all the steps and between steps ( all SP's, hot fixes , patches etc , i read them all , at least i feel so )

Still , i am getting the following error on which i am stuck for the moment :

Microsoft OLE DB Provider for SQL Server error '80040e37'

Invalid object name 'COMMERCE_WEBSITE'.

/LM/w3svc/1/Root/CommercePortal/global.asa, line 657
By the way BizDesk on the other hand seems to work just fine ... at least at the 1-st sight ...

I will really appreciate any help
thanks a lot ,
Kiwi

Comments

  • Options
    mcoAggiemcoAggie Member Posts: 23
    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
  • Options
    mcoAggiemcoAggie Member Posts: 23
    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
  • Options
    KiwiKiwi Member Posts: 5
    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 :wink:

    If you have any other ideas that can fix my problem , i will really appreciate ...

    Best Regards ,
    Kiwi
  • Options
    mcoAggiemcoAggie Member Posts: 23
    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
  • Options
    mandykmandyk Member Posts: 57
    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. :?:
  • Options
    KiwiKiwi Member Posts: 5
    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
  • Options
    KiwiKiwi Member Posts: 5
    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 :D ) .

    Eventually i had it set up for any type of versions.

    Thanks again guys,
    Kiwi
Sign In or Register to comment.