 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Replication / February 2007Error: Syntax error or access violation
In my replication, I noticed the following error. Can you guide me to the right direction to troubleshoot this. In the Last command section: {CALL sp_MSins_GCFD$Sales Header (0x0000000001b52c48, 1, 'ORD211801', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 2006-08-31 00:00:00.000, 2006-09-01 00:00:00.000, 2006-09-01 00:00:00.000, 'Order ORD211801', '', 1753-01-01 00:00:00.000, 0.00000000000000000000, 1753-01-01 00:00:00.000, '', '', '', '', '', '', 0.00000000000000000000, '', 0, 0, '', '', '', '', '', 0, '', 0, '', '', '', 0, 0, '', '', '', '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '' Transaction sequence number and command ID of last execution batch are 0x00000112000A10E3000100000000 and 1. Error messages section: {CALL sp_MSins_GCFD$Sales Header (0x0000000001b52c48, 1, 'ORD211801', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 2006-08-31 00:00:00.000, 2006-09-01 00:00:00.000, 2006-09-01 00:00:00.000, 'Order ORD211801', '', 1753-01-01 00:00:00.000, 0.00000000000000000000, 1753-01-01 00:00:00.000, '', '', '', '', '', '', 0.00000000000000000000, '', 0, 0, '', '', '', '', '', 0, '', 0, '', '', '', 0, 0, '', '', '', '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '' Transaction sequence number and command ID of last execution batch are 0x00000112000A10E3000100000000 and 1. Error details section: Syntax error or access violation (Source: GCFD-SQLWMS (ODBC); Error number: 37000) ------------------------------------------------------------------------------------------------ I tried this on different hours to eliminate the conflicts that might be involved during operational hours. However, it didn't solve the problem. EM Can you tell me what service pack and version you're on, and post up the schema of the offending table and I'd like to repro. Cheers, Paul Ibison SQL Server MVP, www.replicationanswers.com Thanks for the help. I am running sql server2000 sp3 version 8 (windows 2003 server). Here is the complete detail of what's going on. I setup the transactional replication to occur every hour and the initial replication synchronized successfully. This error occurred on the next scheduled time. Here is the information I generated from sql server for this problematic table: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GCFD$Sales Header]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[GCFD$Sales Header] GO CREATE TABLE [dbo].[GCFD$Sales Header] ( [timestamp] [timestamp] NOT NULL , [Document Type] [int] NOT NULL , [No.] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Sell-to Customer No.] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Bill-to Customer No.] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Name] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Name 2] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Address] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Address 2] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [City] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Contact] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Your Reference] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Ship-to Code] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Ship-to Name] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Ship-to Name 2] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Ship-to Address] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Ship-to Address 2] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Ship-to City] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Ship-to Contact] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Order Date] [datetime] NOT NULL , [Posting Date] [datetime] NOT NULL , [Shipment Date] [datetime] NOT NULL , [Posting Description] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Payment Terms Code] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Due Date] [datetime] NOT NULL , [Payment Discount %] [decimal](38, 20) NOT NULL , [Pmt. Discount Date] [datetime] NOT NULL , [Shipment Method Code] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Location Code] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Department Code] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Project Code] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Customer Posting Group] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Currency Code] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Currency Factor] [decimal](38, 20) NOT NULL , [Price Group Code] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Prices Including Tax] [tinyint] NOT NULL , [Allow Quantity Disc.] [tinyint] NOT NULL , [Invoice Disc. Code] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Cust./Item Disc. Gr.] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Language Code] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Salesperson Code] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Order Class] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [No. Printed] [int] NOT NULL , [On Hold] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Applies-to Doc. Type] [int] NOT NULL , [Applies-to Doc. No.] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Bal. Account No.] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Job No.] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Ship] [tinyint] NOT NULL , [Invoice] [tinyint] NOT NULL , [Shipping No.] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Posting No.] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Last Shipping No.] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Last Posting No.] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [VAT Registration No.] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Combine Shipments] [tinyint] NOT NULL , [Reason Code] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Gen. Bus. Posting Group] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [EU 3-Party Trade] [tinyint] NOT NULL , [Transaction Type] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Transport Method] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [VAT Country Code] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Sell-to Customer Name] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Sell-to Customer Name 2] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Sell-to Address] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Sell-to Address 2] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Sell-to City] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Sell-to Contact] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [ZIP Code] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [State] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Country Code] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Sell-to ZIP Code] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Sell-to State] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Sell-to Country Code] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Ship-to ZIP Code] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Ship-to State] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Ship-to Country Code] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Bal. Account Type] [int] NOT NULL , [Exit Point] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Correction] [tinyint] NOT NULL , [Document Date] [datetime] NOT NULL , [External Document No.] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Area] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Transaction Specification] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Payment Method Code] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Shipping Agent Code] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Package Tracking No.] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [No. Series] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Posting No. Series] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Shipping No. Series] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Tax Area Code] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Tax Liable] [tinyint] NOT NULL , [Tax Bus. Posting Group] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Reserve] [int] NOT NULL , [Applies-to ID] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [VAT Base Discount %] [decimal](38, 20) NOT NULL , [Ship-to UPS Zone] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Tax Exemption No.] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Shipper] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Shipped] [tinyint] NOT NULL , [Hold Override] [tinyint] NOT NULL , [Hold Override UserID] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Agency Hold] [tinyint] NOT NULL , [Order Type] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Receiver] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Ready to Pick] [tinyint] NOT NULL , [USDADry Picker Name] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [USDADry Start Time] [datetime] NOT NULL , [USDADry Finish Time] [datetime] NOT NULL , [Agency Arrival Time] [datetime] NOT NULL , [Agency Departure Time] [datetime] NOT NULL , [No. of Out of Stock Codes] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [No. of Refused Stock Codes] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Come Back Order] [tinyint] NOT NULL , [No. Pallets Provided] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [No. Pallets Returned] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Order Checker Name] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Frozen Picker Name] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Frozen Start Time] [datetime] NOT NULL , [Frozen Finish Time] [datetime] NOT NULL , [Refrigerated Picker Name] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Refrigerated Start Time] [datetime] NOT NULL , [Refrigerated Finish Time] [datetime] NOT NULL , [Dry Picker Name] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Dry Start Time] [datetime] NOT NULL , [Dry Finish Time] [datetime] NOT NULL , [Order Checker Start Time] [datetime] NOT NULL , [Order Checker Finish Time] [datetime] NOT NULL , [Order Taken By] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Date Order Taken] [datetime] NOT NULL , [Time Order Taken] [datetime] NOT NULL , [Released By] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Released Date] [datetime] NOT NULL , [Released Time] [datetime] NOT NULL , [Order Method] [int] NOT NULL , [Fund Code] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Function Code] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Branch Code] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Program No.] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Released] [tinyint] NOT NULL , [Grant No.] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Shopper] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Last Modified By] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Last Modified Date] [datetime] NOT NULL , [Last Modified Time] [datetime] NOT NULL , [Delivery Info] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Delivery Zone] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [UNC County] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [UNC Federal Congressional Dist] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [UNC State Congressional Dist] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [UNC Program Category] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [FBC Program Category] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [FBC Geographical Location] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [FBC Metropolitan Area] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [FBC Agency Category] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Picked] [tinyint] NOT NULL , [Pickup Time] [datetime] NOT NULL , [msrepl_tran_version] [uniqueidentifier] NOT NULL ) ON [Data Filegroup 1] GO ALTER TABLE [dbo].[GCFD$Sales Header] WITH NOCHECK ADD CONSTRAINT [GCFD$Sales Header$0] PRIMARY KEY CLUSTERED ( [Document Type], [No.] ) ON [Data Filegroup 1] GO ALTER TABLE [dbo].[GCFD$Sales Header] ADD CONSTRAINT [DF__GCFD$Sale__msrep__3BD5CA13] DEFAULT (newid()) FOR [msrepl_tran_version] GO CREATE UNIQUE INDEX [$1] ON [dbo].[GCFD$Sales Header]([Document Type], [Sell-to Customer No.], [No.]) ON [Data Filegroup 1] GO CREATE UNIQUE INDEX [$2] ON [dbo].[GCFD$Sales Header]([Document Type], [Combine Shipments], [Bill-to Customer No.], [Currency Code], [No.]) ON [Data Filegroup 1] GO CREATE UNIQUE INDEX [$3] ON [dbo].[GCFD$Sales Header]([Document Type], [Released], [Shipment Date], [Pickup Time], [No.]) ON [Data Filegroup 1] GO CREATE UNIQUE INDEX [$4] ON [dbo].[GCFD$Sales Header]([Document Type], [Released], [Location Code], [No.]) ON [Data Filegroup 1] GO CREATE UNIQUE INDEX [$5] ON [dbo].[GCFD$Sales Header]([Shipment Date], [Pickup Time], [Document Type], [No.]) ON [Data Filegroup 1] GO CREATE UNIQUE INDEX [$6] ON [dbo].[GCFD$Sales Header]([Document Type], [Shipment Date], [Pickup Time], [No.]) ON [Data Filegroup 1] GO > Can you tell me what service pack and version you're on, and post up the > schema of the offending table and I'd like to repro. > Cheers, > Paul Ibison SQL Server MVP, www.replicationanswers.com Works in terms of the setup on sp4. Now I need to cause the distribution agent to apply a transaction - please can post up an insert statement otherwise I'll be spending the rest of the afternoon coding it up :) Cheers, Paul Ibison SQL Server MVP, www.replicationanswers.com In addition, I just tried a replication on this table "gcfd$Sales header" and it produced similar error message. See below: Last command: {CALL sp_MSupd_GCFD$Sales Header (0x0000000001b60145,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL Transaction sequence number and command ID of last execution batch are 0x000001120013F83A000100000000 and 3. Error message: Syntax error or access violation Error details: Syntax error or access violation (Source: GCFD-SQLWMS (ODBC); Error number: 37000) I am beginning to suspect that it might be the data in this table causing replication error. Is there anyway to perform and check for invalid characters entered in the table to elminate this possibility? EM > Thanks for the help. I am running sql server2000 sp3 version 8 (windows 2003 > server). [quoted text clipped - 289 lines] > > Cheers, > > Paul Ibison SQL Server MVP, www.replicationanswers.com Em, there's not much I can do with the CALL statement - what I need is the insert on the publisher so I can replicate it on my side. Cheers, Paul Ibison SQL Server MVP, www.replicationanswers.com I am not sure what's you're asking for. Can you walk me through this process to get the information you're looking for? Thanks, EM > Em, > there's not much I can do with the CALL statement - what I need is the > insert on the publisher so I can replicate it on my side. > Cheers, > Paul Ibison SQL Server MVP, www.replicationanswers.com What I really need is an insert statement - insert into table (cols) values (x,y,z...) etc. If I have an insert statement, I can use that on the publisher and this will then replicate to the subscriber. I'll use RedGate's tools tomorrow to try to generate an insert from your data if you haven't posted by then, and we'll see if I can get the same error. Cheers, Paul Ibison SQL Server MVP, www.replicationanswers.com I had the same problem. My custom Stored Procedures looked like: sp_MSins_GroupAttribs^BODY^POWDER_USAGE and I got the exact same error. The carets were messing with the ODBC layer and causing syntax error 37000 I ended up going to the Articles tab (R Click on the Publication) and enclosing the SP in either double-quotes or square brackets and it worked. So give this a try, it sounds like this is your problem. I have a rather large size of data so I took 15 records from the table for this purpose. This is a text-delimited file with the first line for field names. "timestamp","Document Type","No.","Sell-to Customer No.","Bill-to Customer No.","Name","Name 2","Address","Address 2","City","Contact","Your Reference","Ship-to Code","Ship-to Name","Ship-to Name 2","Ship-to Address","Ship-to Address 2","Ship-to City","Ship-to Contact","Order Date","Posting Date","Shipment Date","Posting Description","Payment Terms Code","Due Date","Payment Discount %","Pmt. Discount Date","Shipment Method Code","Location Code","Department Code","Project Code","Customer Posting Group","Currency Code","Currency Factor","Price Group Code","Prices Including Tax","Allow Quantity Disc.","Invoice Disc. Code","Cust./Item Disc. Gr.","Language Code","Salesperson Code","Order Class","No. Printed","On Hold","Applies-to Doc. Type","Applies-to Doc. No.","Bal. Account No.","Job No.","Ship","Invoice","Shipping No.","Posting No.","Last Shipping No.","Last Posting No.","VAT Registration No.","Combine Shipments","Reason Code","Gen. Bus. Posting Group","EU 3-Party Trade","Transaction Type","Transport Method","VAT Country Code","Sell-to Customer Name","Sell-to Customer Name 2","Sell-to Address","Sell-to Address 2","Sell-to City","Sell-to Contact","ZIP Code","State","Country Code","Sell-to ZIP Code","Sell-to State","Sell-to Country Code","Ship-to ZIP Code","Ship-to State","Ship-to Country Code","Bal. Account Type","Exit Point","Correction","Document Date","External Document No.","Area","Transaction Specification","Payment Method Code","Shipping Agent Code","Package Tracking No.","No. Series","Posting No. Series","Shipping No. Series","Tax Area Code","Tax Liable","Tax Bus. Posting Group","Reserve","Applies-to ID","VAT Base Discount %","Ship-to UPS Zone","Tax Exemption No.","Shipper","Shipped","Hold Override","Hold Override UserID","Agency Hold","Order Type","Receiver","Ready to Pick","USDADry Picker Name","USDADry Start Time","USDADry Finish Time","Agency Arrival Time","Agency Departure Time","No. of Out of Stock Codes","No. of Refused Stock Codes","Come Back Order","No. Pallets Provided","No. Pallets Returned","Order Checker Name","Frozen Picker Name","Frozen Start Time","Frozen Finish Time","Refrigerated Picker Name","Refrigerated Start Time","Refrigerated Finish Time","Dry Picker Name","Dry Start Time","Dry Finish Time","Order Checker Start Time","Order Checker Finish Time","Order Taken By","Date Order Taken","Time Order Taken","Released By","Released Date","Released Time","Order Method","Fund Code","Function Code","Branch Code","Program No.","Released","Grant No.","Shopper","Last Modified By","Last Modified Date","Last Modified Time","Delivery Info","Delivery Zone","UNC County","UNC Federal Congressional Dist","UNC State Congressional Dist","UNC Program Category","FBC Program Category","FBC Geographical Location","FBC Metropolitan Area","FBC Agency Category","Picked","Pickup Time","msrepl_tran_version" 0000000001B55D57,1,"ORD210388","A90023","A90000","Food Box - City of Chicago","","","","","","","","Food Box-Trina Davila","","4347 W. Armitage","","Chicago","",2006-08-31 00:00:00,2006-08-17 00:00:00,2006-08-17 00:00:00,"Order ORD210388","NET90",2006-11-15 00:00:00,.00000000000000000000,2006-08-17 00:00:00,"","","000","","FOODBOX","",.00000000000000000000,"",0,1,"A90000","","","","",1,"",0,"","","",0,0,"","","","","",0,"","FOODBOX",0,"","","","Food Box-Trina Davila","","4347 W. Armitage","","Chicago","Vicente Barreiro","","","","60647","IL","","60647","IL","",0,"",0,2006-08-17 00:00:00,"","","","","","","","A-INV+","A-SHPT","",0,"",2,"",.00000000000000000000,"","","",0,0,"",0,"FOODBOX","",0,"",1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,"","",0,"","","","",1753-01-01 00:00:00,1753-01-01 00:00:00,"",1753-01-01 00:00:00,1753-01-01 00:00:00,"",1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,"JNELSON",2006-08-31 00:00:00,1754-01-01 09:06:03.513000000,"DWRIGHT",2006-08-31 00:00:00,1754-01-01 09:40:29.893000000,0,"9","","","BX00050",1,"","","DWRIGHT",2006-08-31 00:00:00,1754-01-01 09:40:34.063000000,"","","","","","PURCHASE","FOODBOX","","","",0,1753-01-01 00:00:00,{44A7059E-7CBB-48A6-A491-156980141B71} 0000000001B00068,1,"ORD210675","A90006","A90000","Food Box - City of Chicago","","","","","","","","Food Box - N Area Comm Srv O","","4740 N. Sheridan Ave.","","Chicago","",2006-08-14 00:00:00,2006-08-15 00:00:00,2006-08-15 00:00:00,"Order ORD210675","NET90",2006-11-12 00:00:00,.00000000000000000000,2006-08-14 00:00:00,"","","000","","FOODBOX","",.00000000000000000000,"",0,1,"A90000","","","","",1,"",0,"","","",0,0,"","","","","",0,"","FOODBOX",0,"","","","Food Box - N Area Comm Srv O","","4740 N. Sheridan Ave.","","Chicago","Joan Fabiano","","","","60640","IL","","60640","IL","",0,"",0,2006-08-14 00:00:00,"","","","","","","A-ORD","A-INV+","A-SHPT","",0,"",2,"",.00000000000000000000,"","","",0,0,"",0,"FOODBOX","",0,"",1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,"","",0,"","","","",1753-01-01 00:00:00,1753-01-01 00:00:00,"",1753-01-01 00:00:00,1753-01-01 00:00:00,"",1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,"DWRIGHT",2006-08-14 00:00:00,1754-01-01 13:47:01.807000000,"DWRIGHT",2006-08-14 00:00:00,1754-01-01 13:49:26.747000000,0,"9","","","BX00021",1,"","","DWRIGHT",2006-08-14 00:00:00,1754-01-01 13:49:30.483000000,"","","","","","PURCHASE","FOODBOX","","","",0,1753-01-01 00:00:00,{9C716525-6C44-4156-AEB7-6FD30E3D6330} 0000000001AD0EF0,1,"ORD210677","A90021","A90000","Food Box - City of Chicago","","","","","","","","Food Box- Garf Comm Svc Off","","10 S. Kedzie","","Chicago","",2006-08-14 00:00:00,2006-08-15 00:00:00,2006-08-15 00:00:00,"Order ORD210677","NET90",2006-11-12 00:00:00,.00000000000000000000,2006-08-14 00:00:00,"","","000","","FOODBOX","",.00000000000000000000,"",0,1,"A90000","","","","",1,"",0,"","","",0,0,"","","","","",0,"","FOODBOX",0,"","","","Food Box- Garf Comm Svc Off","","10 S. Kedzie","","Chicago","Andrew Brown","","","","60612","IL","","60612","IL","",0,"",0,2006-08-14 00:00:00,"","","","","","","A-ORD","A-INV+","A-SHPT","",0,"",2,"",.00000000000000000000,"","","",0,0,"",0,"FOODBOX","",0,"",1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,"","",0,"","","","",1753-01-01 00:00:00,1753-01-01 00:00:00,"",1753-01-01 00:00:00,1753-01-01 00:00:00,"",1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,"DWRIGHT",2006-08-14 00:00:00,1754-01-01 13:50:14.007000000,"DWRIGHT",2006-08-14 00:00:00,1754-01-01 13:52:45.387000000,0,"9","","","BX00054",1,"","","DWRIGHT",2006-08-14 00:00:00,1754-01-01 13:53:12.060000000,"","","","","","PURCHASE","FOODBOX","","","",0,1753-01-01 00:00:00,{A72C7617-12BD-40BE-8268-3FE830AE7747} 0000000001AD0FD9,1,"ORD210678","A90023","A90000","Food Box - City of Chicago","","","","","","","","Food Box-Trina Davila","","4347 W. Armitage","","Chicago","",2006-08-14 00:00:00,2006-08-15 00:00:00,2006-08-15 00:00:00,"Order ORD210678","NET90",2006-11-12 00:00:00,.00000000000000000000,2006-08-14 00:00:00,"","","000","","FOODBOX","",.00000000000000000000,"",0,1,"A90000","","","","",0,"",0,"","","",0,0,"","","","","",0,"","FOODBOX",0,"","","","Food Box-Trina Davila","","4347 W. Armitage","","Chicago","Vicente Barreiro","","","","60647","IL","","60647","IL","",0,"",0,2006-08-14 00:00:00,"","","","","","","A-ORD","A-INV+","A-SHPT","",0,"",2,"",.00000000000000000000,"","","",0,0,"",0,"FOODBOX","",0,"",1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,"","",0,"","","","",1753-01-01 00:00:00,1753-01-01 00:00:00,"",1753-01-01 00:00:00,1753-01-01 00:00:00,"",1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,"DWRIGHT",2006-08-14 00:00:00,1754-01-01 13:53:43.017000000,"DWRIGHT",2006-08-14 00:00:00,1754-01-01 13:54:55.293000000,0,"9","","","BX00050",1,"","","DWRIGHT",2006-08-14 00:00:00,1754-01-01 13:56:27.840000000,"","","","","","PURCHASE","FOODBOX","","","",0,1753-01-01 00:00:00,{96EC68CD-FBF7-4CE9-806B-F4384F4F639C} 0000000001AD0FE8,1,"ORD210679","A90026","A90000","Food Box - City of Chicago","","","","","","","","Food Box-Emergency Services","","10 S. Kedzie","","Chicago","",2006-08-14 00:00:00,2006-08-15 00:00:00,2006-08-15 00:00:00,"Order ORD210679","NET90",2006-11-12 00:00:00,.00000000000000000000,2006-08-14 00:00:00,"","","000","","FOODBOX","",.00000000000000000000,"",0,1,"A90000","","","","",1,"",0,"","","",0,0,"","","","","",0,"","FOODBOX",0,"","","","Food Box-Emergency Services","","10 S. Kedzie","","Chicago","Ruth Vedgood","","","","60624","IL","","60624","IL","",0,"",0,2006-08-14 00:00:00,"","","","","","","A-ORD","A-INV+","A-SHPT","",0,"",2,"",.00000000000000000000,"","","",0,0,"",0,"FOODBOX","",0,"",1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,"","",0,"","","","",1753-01-01 00:00:00,1753-01-01 00:00:00,"",1753-01-01 00:00:00,1753-01-01 00:00:00,"",1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,"DWRIGHT",2006-08-14 00:00:00,1754-01-01 13:56:30.340000000,"DWRIGHT",2006-08-14 00:00:00,1754-01-01 13:57:11.923000000,0,"9","","","BX00044",1,"","","DWRIGHT",2006-08-14 00:00:00,1754-01-01 13:57:14.393000000,"","","","","","PURCHASE","FOODBOX","","","",0,1753-01-01 00:00:00,{8B3B02A4-4131-4ECB-8A10-13C51A68AA25} 0000000001B00048,1,"ORD210698","A00258","A00258","Soldiers of the Cross","","3429 W. North Ave.","","Chicago","Benjamin Ruiz","","","Soldiers of the Cross","","3429 W. North Ave.","","Chicago","Benjamin Ruiz",2006-08-15 00:00:00,2006-08-15 00:00:00,2006-08-15 00:00:00,"Order ORD210698","NET30",2006-09-14 00:00:00,.00000000000000000000,2006-08-15 00:00:00,"PICK-UP","","000","","AGENCY","",.00000000000000000000,"",0,0,"","","","","",0,"",0,"","","",0,0,"","","","","",0,"","AGENCY",0,"","","","Soldiers of the Cross","","3429 West North Ave","","Chicago","Benjamin Ruiz","60647","IL","","60647","IL","","60647","IL","",0,"",0,2006-08-15 00:00:00,"","","","","","","A-ORD","A-INV+","A-SHPT","",0,"",2,"",.00000000000000000000,"","","",0,0,"",0,"A-MART","",0,"",1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,"","",0,"","","","",1753-01-01 00:00:00,1753-01-01 00:00:00,"",1753-01-01 00:00:00,1753-01-01 00:00:00,"",1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,"MVAZQUEZ",2006-08-15 00:00:00,1754-01-01 07:59:11.593000000,"MVAZQUEZ",2006-08-16 00:00:00,1754-01-01 06:15:24.030000000,3,"1","","","PY00117",1,"","","ICTEMP",2006-08-21 00:00:00,1754-01-01 07:10:36.663000000,"","","COOK","","","PANTRY","PANTRY","","","",0,1753-01-01 00:00:00,{CDBA8F18-F8AD-4137-B318-281814F73190} 0000000001AE21A8,1,"ORD210796","A00478","A00478","COMMUNITY KITCHENS (GCFD)","","4100 West Ann Lurie Place","","","GCFD","","","COMMUNITY KITCHENS (GCFD)","","1116 North Kedzie","","Chicago","Richard Margotta",2006-08-16 00:00:00,2006-08-16 00:00:00,2006-08-16 00:00:00,"Order ORD210796","NET30",2006-09-15 00:00:00,.00000000000000000000,2006-08-16 00:00:00,"","","181","","INTERNAL","",.00000000000000000000,"INTERNAL",0,0,"","","","","",0,"",0,"","","",0,0,"","","","","",0,"","CK-GCFD",0,"","","","COMMUNITY KITCHENS (GCFD)","","1116 North Kedzie","","Chicago","Richard Margotta","60632","IL","","60651","IL","","60651","IL","",0,"",0,2006-08-16 00:00:00,"","","","","","","A-ORD","A-INV+","A-SHPT","",0,"",2,"",.00000000000000000000,"","","",0,0,"",0,"A-MART","",0,"",1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,"","",0,"","","","",1753-01-01 00:00:00,1753-01-01 00:00:00,"",1753-01-01 00:00:00,1753-01-01 00:00:00,"",1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,"MVAZQUEZ",2006-08-16 00:00:00,1754-01-01 09:17:43.453000000,"",1753-01-01 00:00:00,1753-01-01 00:00:00,3,"1","","","ON00471",0,"","","MVAZQUEZ",2006-08-16 00:00:00,1754-01-01 09:18:59.500000000,"","","COOK","","","","ONSITE","","","",0,1753-01-01 00:00:00,{1B3A9BD5-7373-4D8D-B6FB-89B607E40B7B} 0000000001AE59F4,1,"ORD210831","A01055","A01055","Little Sisters of the Poor","","2325 N. Lakewood","","Chicago","Ligia Schmidt","","","Little Sisters of the Poor","","2325 N. Lakewood","","Chicago","Ligia Schmidt",2006-08-16 00:00:00,2006-08-16 00:00:00,2006-08-16 00:00:00,"Order ORD210831","",2006-08-16 00:00:00,.00000000000000000000,2006-08-16 00:00:00,"PICK-UP","","000","","AGENCY","",.00000000000000000000,"",0,1,"","","","","",0,"",0,"","","",0,0,"","","","","",0,"","AGENCY",0,"","","","Little Sisters of the Poor","","2325 N. Lakewood","","Chicago","Ligia Schmidt","60614","IL","","60614","IL","","60614","IL","",0,"",0,2006-08-16 00:00:00,"","","","","","","A-ORD","A-INV+","A-SHPT","",0,"",2,"",.00000000000000000000,"","","",0,0,"",1,"A-MART","",0,"",1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,"","",0,"","","","",1753-01-01 00:00:00,1753-01-01 00:00:00,"",1753-01-01 00:00:00,1753-01-01 00:00:00,"",1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,"MVAZQUEZ",2006-08-16 00:00:00,1754-01-01 13:10:35.390000000,"",1753-01-01 00:00:00,1753-01-01 00:00:00,3,"1","","","ON00890",0,"","","MVAZQUEZ",2006-08-16 00:00:00,1754-01-01 13:11:43.657000000,"","","COOK","","","PANTRY","ONSITE","","","",0,1753-01-01 00:00:00,{D9B87199-5417-4948-ABE2-8401434FFDB3} 0000000001AEB2B5,1,"ORD210855","A00856","A00856","Praise Tabernacle Baptist Ch","","9511 South Commercial","","Chicago","Jeannie Johnson","","","Praise Tabernacle Baptist Ch","","9511 South Commercial Avenue","","Chicago","Jeannie Johnson",2006-08-17 00:00:00,2006-08-16 00:00:00,2006-08-16 00:00:00,"Order ORD210855","NET30",2006-09-15 00:00:00,.00000000000000000000,2006-08-16 00:00:00,"PICK-UP","","000","","AGENCY","",.00000000000000000000,"",0,1,"","","","","",0,"",0,"","","",0,0,"","","","","",0,"","AGENCY",0,"","","","Praise Tabernacle Baptist Ch","","9511 South Commercial Avenue","","Chicago","Jeannie Johnson","60617","IL","","60617","IL","","60617","IL","",0,"",0,2006-08-16 00:00:00,"","","","","","","A-ORD","A-INV+","A-SHPT","",0,"",2,"",.00000000000000000000,"","","",0,0,"",1,"A-MART","",0,"",1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,"","",0,"","","","",1753-01-01 00:00:00,1753-01-01 00:00:00,"",1753-01-01 00:00:00,1753-01-01 00:00:00,"",1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,"MVAZQUEZ",2006-08-17 00:00:00,1754-01-01 06:57:46.350000000,"",1753-01-01 00:00:00,1753-01-01 00:00:00,3,"1","","","ON00751",0,"","","MVAZQUEZ",2006-08-17 00:00:00,1754-01-01 06:58:44.803000000,"","MRWASHINGT","","","","PANTRY","ONSITE","","","",0,1753-01-01 00:00:00,{0B5E7BB6-F335-48E0-B14F-73E131FEBE10} 0000000001AF11D1,1,"ORD210940","A00392","A00392","Morgan Park Pentecostal","","11604 S. Bishop","","Chicago","Ms. Richmond","","","Morgan Pk Pentecostal Church","","1657 West Monterey","","Chicago","Bernice Richmond",2006-08-17 00:00:00,2006-08-17 00:00:00,2006-08-17 00:00:00,"Order ORD210940","NET30",2006-09-16 00:00:00,.00000000000000000000,2006-08-17 00:00:00,"PICK-UP","","000","","AGENCY","",.00000000000000000000,"",0,0,"","","","","",0,"",0,"","","",0,0,"","","","","",0,"","AGENCY",0,"","","","Morgan Park Pentecostal Church","","11604 South Bishop","","Chicago","Ms. Richmond/Ms. Butler","60643","IL","","60643","IL","","60643","IL","",0,"",0,2006-08-17 00:00:00,"","","","","","","A-ORD","A-INV+","A-SHPT","",0,"",2,"",.00000000000000000000,"","","",0,0,"",0,"A-MART","",0,"",1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,"","",0,"","","","",1753-01-01 00:00:00,1753-01-01 00:00:00,"",1753-01-01 00:00:00,1753-01-01 00:00:00,"",1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,"MVAZQUEZ",2006-08-17 00:00:00,1754-01-01 14:19:00.490000000,"MVAZQUEZ",2006-08-17 00:00:00,1754-01-01 14:23:39.813000000,3,"1","","","ON00387",1,"","","MVAZQUEZ",2006-08-17 00:00:00,1754-01-01 14:23:48.780000000,"","","","","","","ONSITE","","","",0,1753-01-01 00:00:00,{05A5D00E-7C05-40CF-B898-0D20A3A32B78} 0000000001AF86C7,1,"ORD210977","A00456","A00456","LSSI BHS Detox Program","","5517 North Kenmore","","Chicago","Denise Schott","","","LSSI BHS Detox Program","","5517 North Kenmore","","Chicago","",2006-08-18 00:00:00,2006-08-18 00:00:00,2006-08-18 00:00:00,"Order ORD210977","NET90",2006-11-16 00:00:00,.00000000000000000000,2006-08-18 00:00:00,"","","000","","AGENCY","",.00000000000000000000,"",0,0,"","","","","",0,"",0,"","","",0,0,"","","","","",0,"","AGENCY",0,"","","","LSSI BHS Detox Program","","5517 North Kenmore","","Chicago","Denise Schott","60640","IL","","60640","IL","","60640","IL","",0,"",0,2006-08-18 00:00:00,"","","","","","","A-ORD","A-INV+","A-SHPT","",0,"",2,"",.00000000000000000000,"","","",0,0,"",0,"A-MART","",0,"",1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,"","",0,"","","","",1753-01-01 00:00:00,1753-01-01 00:00:00,"",1753-01-01 00:00:00,1753-01-01 00:00:00,"",1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,"MVAZQUEZ",2006-08-18 00:00:00,1754-01-01 09:17:04.713000000,"MVAZQUEZ",2006-08-18 00:00:00,1754-01-01 09:24:12.017000000,3,"1","","","ON00450",1,"","","MVAZQUEZ",2006-08-18 00:00:00,1754-01-01 09:24:16.730000000,"","","","","","","ONSITE","","","",0,1753-01-01 00:00:00,{2AA8E007-D456-4806-A066-90DF36A27F8F} 0000000001B03D45,1,"ORD211060","A00839","A00839","Van Produce Delivery Order","","","","","Deb Somers-Larney","","","General Produce Mobile","","4100 West Ann Lurie Place","","Chicago","Deborah Somers-Larney",2006-08-21 00:00:00,2006-08-18 00:00:00,2006-08-18 00:00:00,"Order ORD211060","",2006-08-18 00:00:00,.00000000000000000000,2006-08-18 00:00:00,"","","000","","AGENCY","",.00000000000000000000,"INTERNAL",0,1,"","","","","",0,"",0,"","","",0,0,"","","","","",0,"","AGENCY",0,"","","","Produce Deliveries Misc.","","4100 West Ann Lurie Place","","Chicago","Deborah Somers-Larney","","IL","","60632","IL","","60632","IL","",0,"",0,2006-08-18 00:00:00,"","","","","","","A-ORD","A-INV+","A-SHPT","",0,"",2,"",.00000000000000000000,"","","",0,0,"",0,"VAN1","",0,"",1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,"","",0,"","","","",1753-01-01 00:00:00,1753-01-01 00:00:00,"",1753-01-01 00:00:00,1753-01-01 00:00:00,"",1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,"AMCLERK",2006-08-21 00:00:00,1754-01-01 09:36:13.203000000,"AMCLERK",2006-08-21 00:00:00,1754-01-01 09:37:45.640000000,0,"1","","","PM00001",1,"","","AMCLERK",2006-08-21 00:00:00,1754-01-01 09:38:04.187000000,"","","COOK","","","PANTRY","PRODUCE","","","",0,1753-01-01 00:00:00,{CB732596-C1B4-4A4E-B5BC-585BB4FE0228} 0000000001B06CC7,1,"ORD211103","A01002","A01002","Anointed Word Internat'l Min.","","3434 West 159th Street","","Markham","Attn: Treasurer","","","Anointed Word Internat'l Min","","3434 West 159th Street","","Markham","Pastor Dr. Jacqueline Anderson",2006-08-21 00:00:00,2006-08-21 00:00:00,2006-08-21 00:00:00,"Order ORD211103","NET30",2006-09-20 00:00:00,.00000000000000000000,2006-08-21 00:00:00,"","","000","","AGENCY","",.00000000000000000000,"",0,1,"","","","","",0,"",0,"","","",0,0,"","","","","",0,"","AGENCY",0,"","","","Anointed Word Internat'l Min.","","3434 West 159th Street","","Markham","Pastor Dr. Jacqueline Anderson","60428","IL","","60426","IL","","60426","IL","",0,"",0,2006-08-21 00:00:00,"","","","","","","A-ORD","A-INV+","A-SHPT","",0,"",2,"",.00000000000000000000,"","","",0,0,"",0,"A-MART","",0,"",1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,"","",0,"","","","",1753-01-01 00:00:00,1753-01-01 00:00:00,"",1753-01-01 00:00:00,1753-01-01 00:00:00,"",1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,"MVAZQUEZ",2006-08-21 00:00:00,1754-01-01 13:38:11.867000000,"MVAZQUEZ",2006-08-21 00:00:00,1754-01-01 13:41:48.727000000,0,"1","","","ON00836",1,"","","MVAZQUEZ",2006-08-21 00:00:00,1754-01-01 13:41:53.633000000,"","","COOK","","","PANTRY","ONSITE","","","",0,1753-01-01 00:00:00,{F41F9B8E-F827-4FC6-9030-3F483BF58CD9} 0000000001B0C9EB,1,"ORD211123","A00276","A00276","Faith Tabernacle Church South","","8210 South Cornell","","Chicago","Willie Mae Anderson","","","Faith Tabernacle Church","","8210 South Cornell","","Chicago","Willie Mae Anderson",2006-08-21 00:00:00,2006-08-14 00:00:00,2006-08-14 00:00:00,"Order ORD211123","NET30",2006-09-13 00:00:00,.00000000000000000000,2006-08-14 00:00:00,"","","000","","AGENCY","",.00000000000000000000,"",0,0,"","","","","",0,"",0,"","","",0,0,"","","","","",0,"","AGENCY",0,"","","","Faith Tabernacle Church","","8210 South Cornell","","Chicago","Willie Mae Anderson","60617","IL","","60617","IL","","60617","IL","",0,"",0,2006-08-14 00:00:00,"","","","","","","A-ORD","A-INV+","A-SHPT","",0,"",2,"",.00000000000000000000,"","","",0,0,"",0,"A-MART","",0,"",1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,"","",0,"","","","",1753-01-01 00:00:00,1753-01-01 00:00:00,"",1753-01-01 00:00:00,1753-01-01 00:00:00,"",1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,"MVAZQUEZ",2006-08-21 00:00:00,1754-01-01 16:34:44.057000000,"MVAZQUEZ",2006-08-21 00:00:00,1754-01-01 16:35:26.320000000,3,"1","","","ON00272",1,"","","MVAZQUEZ",2006-08-21 00:00:00,1754-01-01 16:35:42.790000000,"","","","","","","ONSITE","","","",0,1753-01-01 00:00:00,{4D2C00D1-E0D7-4042-997F-5D1D93EA6EAA} 0000000001B103D5,1,"ORD211184","A00268","A00268","Community Mental Health","","8704 S. Constance Ave.","Attn: Fiscal Operations","Chicago","Rochelle Cross","","","Community Mental Health","","8704 S. Constance Ave.","","Chicago","",2006-08-22 00:00:00,2006-08-22 00:00:00,2006-08-22 00:00:00,"Order ORD211184","NET30",2006-09-21 00:00:00,.00000000000000000000,2006-08-22 00:00:00,"","","000","","AGENCY","",.00000000000000000000,"",0,0,"","","","","",0,"",0,"","","",0,0,"","","","","",0,"","AGENCY",0,"","","","Community Mental Health","","8704 S. Constance Ave.","","Chicago","Rochelle Cross","60617","IL","","60617","IL","","60617","IL","",0,"",0,2006-08-22 00:00:00,"","","","","","","A-ORD","A-INV+","A-SHPT","",0,"",2,"",.00000000000000000000,"","","",0,0,"",0,"A-MART","",0,"",1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,"","",0,"","","","",1753-01-01 00:00:00,1753-01-01 00:00:00,"",1753-01-01 00:00:00,1753-01-01 00:00:00,"",1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,"MVAZQUEZ",2006-08-22 00:00:00,1754-01-01 10:12:15.703000000,"MVAZQUEZ",2006-08-22 00:00:00,1754-01-01 10:14:06.947000000,3,"1","","","ON00264",1,"","","MVAZQUEZ",2006-08-22 00:00:00,1754-01-01 10:14:09.957000000,"","","","","","","ONSITE","","","",0,1753-01-01 00:00:00,{E2440B6B-3D70-4CEC-9C3E-C1AE1619B3B9} EM > In my replication, I noticed the following error. Can you guide me to the > right direction to troubleshoot this. I've the same problem. The reason is the names of the articles with special Characters like “$,<,>”. If the sepcial Characters are only in the names of the tables no problem, but if there are also data with special characters the 37000 appear when the records are inserted. I’ve SQLServer 2000 Sp3. I don’t now if the SP4 solve the problem. I can’t rename the original tables. ¿Could somebody tell us the solution? > I have a rather large size of data so I took 15 records from the table for > this purpose. This is a text-delimited file with the first line for field [quoted text clipped - 296 lines] > Cornell","","Chicago","Willie Mae Anderson",2006-08-21 00:00:00,2006-08-14 > 00:00:00,2006-08-14 00:00:00,"Order ORD211123","NET30",2006-09-13 That's the direction I am heading toward too. However, there are too much data to go through to confirm this process. I am still looking for ways to check for invalid or special characters in the table. Can someone help? > I've the same problem. The reason is the names of the articles with special > Characters like “$,<,>”. If the sepcial Characters are only in the names of [quoted text clipped - 294 lines] > > 00:00:00,"",1753-01-01 00:00:00,1753-01-01 00:00:00,"",1753-01-01 > > 00:00:00,1753-01-01 00:00:00,1753-01-01 00:00:00,1753-01-01 Hi Emgeneral: are you replicating Navision db? If yes, I guess the problem is with the space in tablename. This makes repl cmd (CALL sp_MSins_table"space"name) to take tablename after "space" as para. and we get the syntax error. My experience is to fix this space with [tablename]. It work for me. > That's the direction I am heading toward too. However, there are too much > data to go through to confirm this process. I am still looking for ways to [quoted text clipped - 292 lines] > > > Word Internat'l Min.","","3434 West 159th Street","","Markham","Pastor Dr. > > > Jacqueline Hello mymoodle, Yes, I am trying to replicate a Navision db. I have over 20 tables scheduled to replication at a regular interval of time and this specific table "Sales Header" returned with syntax error mentioned. Because of the special characters in the table table, I have created alias to reference the table name with "no space" and "$" sign. I will try again to verify the "extra space" you're referring to. Meanwhile, can you provide precise procedures to assist me with Replication to confirm I am doing it properly and correctly? Thanks, EM. > Hi Emgeneral: > are you replicating Navision db? [quoted text clipped - 290 lines] > > > > 00:00:00,1754-01-01 > > > > 09:38:04.187000000,"","","COOK","","","PANTRY","PRODUCE","","","",0,1753-01-01 00:00:00,{CB732596-C1B4-4A4E-B5BC-585BB4FE0228} Hi EM: check sysarticles table in publication db. You'll find the update, insert, delete specified commands for each table. It looks like Call sp_MSins_tablename, CALL sp_MSdel_tablename, MCALL MSupd_tablename. SQL 2000 doesn't support replicaton with space in tablename. That's where the problem comes from. My experience is like 1. Repl with Sync: stop log reader and distrib agent first at distributor, This will prevent log reader to write wrong sp (tablename with sapce) into distribution db at distributor. update sysarticles for insert, update, delete command using "+" in TSQL to attached [ and ] to the begining and end of sp (eg, CALL [sp_MSins_table space name]. 2. Repl without Sync: run sp_scriptpublicationcustomprocs to generate sp in subscribtion db, update sysarticles in publishing db with [sp_MSins_table name] for ins, upd, del. Don't update sysarticles before sp_scriptpublicationcustomprocs. This will create wrong sp name with extra [ and ]. BTW, do you have problem with timestamp in replcation Navision. I manually filter timestamp column. Do you have any idea to do this smarter. Navision has thouthands of table. It tooks me a lot of time to filter timestamp column from each table. My Navision has timestamp for each table. I'm dealing with identity_insert on for each sp_MSins_table, sp_MSupd_table to solve identity replication problem at subscribtion. If you have this kind of experience, any idea or information will help. Hope this help. Good Luck. Mynoodle. emgeneral 寫道： > Hello mymoodle, > [quoted text clipped - 304 lines] > > > > > 00:00:00,1754-01-01 > > > > > 09:38:04.187000000,"","","COOK","","","PANTRY","PRODUCE","","","",0,1753-01-01 00:00:00,{CB732596-C1B4-4A4E-B5BC-585BB4FE0228} Just wanted to give you ALL a quick update on this and thanks for all the help and guidance that was provided to me. It was indeed the extra space and specific characters in the sp_MSins_<tablename> command as the result of my error. After correcting that, it is now working. Daniel -- Thanks for the help. I truly appreciate it. To date, I haven't experienced any issue with the timestamp field you mentioned in Navision. Other than the syntax error I had on this specific table, the rest of the tables replicate fine. What specific problem are you having with timestamp? EM > Hi EM: > check sysarticles table in publication db. You'll find the update, [quoted text clipped - 288 lines] > > > > > > 00:00:00,"PICK-UP","","000","","AGENCY","",.00000000000000000000,"",0,0,"","","","","",0,"",0,"","","",0,0,"","","","","",0,"","AGENCY",0,"","","","Morgan > > > > > > Park Pentecostal Church","","11604 South Bishop","","Chicago","Ms. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.