Untitled Document
Results 1 to 9 of 9

Thread: "Invalid object name..." >> Error message yielded for ShipRush insert statement

  1. #1
    I'm running ShipRush version 7.0.0.31950 and unable to insert shipment information into a database. I get the following error: "Invalid object name 'dbo.ShipmentHistory'. Would you please offer some guidance how I can get ShipRush to update my database table and would you be able to post the variables that are available (eg., %TRACKINGNUMBER%, %RecordID%, etc.). The online file has only a few and after reviewing the XML document created know there must be more available. Thanks in advance for posting those.

    [Background]
    I have built my own SQL 2000 database and table to house shipment information in it. I've created a user that has the appropriate permissions to the database and table and have configured the userid connection in ShipRush (settings | program settings | cm settings).

    I've created the following sql statement and can test\verify using SQL Query Analyzer that it's valid. I've also tested the user's ability to execute the statement and it's good as well.


    /* ------ Insert Statement ------ */
    DECLARE @RecordID varchar(100)
    DECLARE @TrackingNumber varchar(100)

    SET @RecordID = '%RecordID%'
    SET @TrackingNumber = '%TRACKINGNUMBER%'

    INSERT INTO dbo.ShipmentHistory (RecordID, PackageTrackingNumber) VALUES ( @RecordID, @TrackingNumber)


    Upon recommendation, I've also tested the following code as well. It doesn't yield any positive\insert statements either.

    DECLARE @RecordID varchar(100)
    DECLARE @TrackingNumber varchar(100)

    SET @RecordID = '%RecordID%'
    SET @TrackingNumber = '%TRACKINGNUMBER%'

    INSERT INTO [dbo].[ShipmentHistory] ( [RecordID], [PackageTrackingNumber] ) VALUES ( @RecordID, @TrackingNumber)


    [ Other ]
    I've even monitored via SQL Profiler to see connection information. I can verify that it connects when seting up the connection information in ShipRush and testing it. However, when I print a label, no connection is ever made; I just get an error screen with the above "Invalid...."

    Thoughts?

  2. #2

    Join Date
    Apr 2004
    Location
    Seattle
    Posts
    8,957
    Blog Entries
    1
    SYSOPR is offline
    >> "Invalid object name 'dbo.ShipmentHistory'.

    That indicates that the SQL connection is not in a database with such an object.

    There are various ways to manage this...

    1) In the ADO connection string, specify the database name

    2) In SQL itself, configure the SQL user name to use the desired database as the user's default database

    3) Specify the database name in the sql itself. E.g. instead of "dbo.shipmenthistory" say "mydatabase.dbo.shipmenthistory" (this syntax works in SQL analyzer also, so you can validate it).


    Keep us posted!
    -----------------------------------
    The Blog: http://forums.zfirm.com/blog.php

    YouTube channel: http://youtube.com/shiprush

    Thank you for using ShipRush!
    Reply With Quote

  3. #3
    1. the database is stored in the connString along with the userid.
    >> Initial Catalog=ShipRushTmp;

    2. assign as the default database
    >> already done when I setup the user.

    3. Specify the db in the sql statement.

    already tried it. still doesn't work.

    DECLARE @RecordID varchar(100)
    DECLARE @TrackingNumber varchar(100)

    SET @RecordID = '%RecordID%'
    SET @TrackingNumber = '%TRACKINGNUMBER%'

    INSERT INTO ShipRushTmp.dbo.ShipmentHistory (RecordID, PackageTrackingNumber) VALUES ( @RecordID, @TrackingNumber)


    /*-- also changed the statement to try this too -- */

    DECLARE @RecordID varchar(100)
    DECLARE @TrackingNumber varchar(100)

    SET @RecordID = '%RecordID%'
    SET @TrackingNumber = '%TRACKINGNUMBER%'

    INSERT INTO [ShipRushTmp].[dbo].[ShipmentHistory] ([RecordID], [PackageTrackingNumber]) VALUES ( @RecordID, @TrackingNumber)



    ---------------------

    got any other ideas? it's like the program forgets there's even a connString specified.

  4. #4

    Join Date
    Apr 2004
    Location
    Seattle
    Posts
    8,957
    Blog Entries
    1
    SYSOPR is offline
    When everything is haywire, start from the beginning and work up.

    a) Use a super simple, one line piece of SQL
    b) Walk it through all the way
    c) Check the connection strings using an ADO based tool (SQL Analyzer doesn't count in this regard)


    If still stuck, give our support a call. It may be a paid call, but it can help move the ball down the field.
    -----------------------------------
    The Blog: http://forums.zfirm.com/blog.php

    YouTube channel: http://youtube.com/shiprush

    Thank you for using ShipRush!
    Reply With Quote

  5. #5
    tried these "simple" statements and all did not work.

    ---------------------------------

    INSERT INTO ShipRushTmp.dbo.ShipmentHistory (RecordID, PackageTrackingNumber) VALUES ( '58', '123')

    INSERT INTO dbo.ShipmentHistory (RecordID, PackageTrackingNumber) VALUES ( '58', '123')

    INSERT INTO ShipmentHistory (RecordID, PackageTrackingNumber) VALUES ( '58', '123')

    ---------------------------------

    I've got SQL Profiler watching the whole thing and there's no activity being generated for the specified userid.

    SQL Integrated Securities option for the ADO connection string didn't work for me either.

    What does your working connString look like? Mind posting that?

  6. #6

    Join Date
    Apr 2004
    Posts
    16,766
    SYSOPS is offline
    Could you dumb it down even further?

    Create a simple stored procedure, and just trigger the sproc for the write back function. Does it trigger?

    SYSOPS
    Have Questions? Ask the ShipRush Knowledge Base: https://shiprush.com/kbase
    Reply With Quote

  7. #7
    sorry, I don't think making a stored proc for this will do since SR isn't even able to invoke the connection string specified.

    think it's a lost cause with ADO insert\update in this build and I'll have to go the XML file route instead.

  8. #8

    Join Date
    Apr 2004
    Location
    Seattle
    Posts
    8,957
    Blog Entries
    1
    SYSOPR is offline
    I don't think we can nail this one here on the forums. Contact the ShipRush team by phone...
    -----------------------------------
    The Blog: http://forums.zfirm.com/blog.php

    YouTube channel: http://youtube.com/shiprush

    Thank you for using ShipRush!
    Reply With Quote

  9. #9

    Join Date
    Apr 2004
    Posts
    16,766
    SYSOPS is offline
    As a test, what if you run ShipRush SQL with the Northwinds database? Use the example from the helpfile for the queries:
    http://www.zfirm.com/Product%5FDocum...__Examples.htm

    Does it get and post back correctly?

    SYSOPS
    Have Questions? Ask the ShipRush Knowledge Base: https://shiprush.com/kbase
    Reply With Quote

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •