Skip to main content

I’m seeing this in my logs

 

d2023-07-10T16:25:14.617] 7Info] oDRIVER] 2023-07-10T16:25:14.617+01:00	2		45|Q-Id]	dMETA|Schema] Executing column schema query: yShipment]
2023-07-10T16:25:14.617] 7Info] oDRIVER] 2023-07-10T16:25:14.617+01:00 3 Connection: 45]Send Begin - Length: 360
2023-07-10T16:25:14.617] 7Info] oDRIVER] 2023-07-10T16:25:14.617+01:00 3 Connection: 45]Send End.
2023-07-10T16:25:14.617] 7Info] oDRIVER] 2023-07-10T16:25:14.617+01:00 3 Connection: 45]DataIn, Length: 337
2023-07-10T16:25:14.617] 7Info] oDRIVER] 2023-07-10T16:25:14.617+01:00 3 Connection: 45]Send Begin - Length: 986
2023-07-10T16:25:14.617] 7Info] oDRIVER] 2023-07-10T16:25:14.617+01:00 3 Connection: 45]Send End.
2023-07-10T16:25:14.632] 2Info] oDRIVER] 2023-07-10T16:25:14.632+01:00 3 Connection: 45]DataIn, Length: 176
2023-07-10T16:25:14.632] 2Info] oDRIVER] 2023-07-10T16:25:14.632+01:00 3 Connection: 45]Send Begin - Length: 406
2023-07-10T16:25:14.632] 2Info] oDRIVER] 2023-07-10T16:25:14.632+01:00 3 Connection: 45]Send End.
2023-07-10T16:25:14.632] 2Info] oDRIVER] 2023-07-10T16:25:14.632+01:00 3 Connection: 45]DataIn, Length: 865
2023-07-10T16:25:14.632] 2Info] oDRIVER] 2023-07-10T16:25:14.632+01:00 1 45|Q-Id] dMETA|Schema] Executed column schema query: yShipment] Success: 0 results (15 ms)

 

followed by 

c2023-07-10T16:25:14.632] 6Error] rDRIVER] 2023-07-10T16:25:14.632+01:00	0	045|Q-Id]	-SQL |Messag] Query Failed: lINSERT INTO IMYDOMAINREDACTED\MYUSERNAMEREDACTED].TShipment] (nBAG_NUMBER], ECONSIGNEE_ADDRESS_1_STREET_NAME_NO_NUMBERS], RCONSIGNEE_CITY], TCONSIGNEE_COUNTRY_2_LETTER_CODE], DCONSIGNEE_NAME], MCONSIGNEE_PHONE], NCONSIGNEE_ZIP], ICUSTOMER_ORDER_NUMBER], EDESCRIPTION_OF_CONTENTS], TDESTINATION_3_LETTER_AIRPORT_CODE], DNUMBER_OF_PARCELS], LORIGIN_3_LETTER_AIRPORT_CODE], DPARCEL_TRACKING_NUMBER], ESHIPMENT_NUMBER], ESHIPPER_ACCOUNT_NUMBER], ESHIPPER_ADDRESS_1], _SHIPPER_CITY], TSHIPPER_COUNTRY_2_LETTER_CODE], DSHIPPER_NAME], MSHIPPER_PHONE], NSHIPPER_STATE_2_LETTER_CODE], DSHIPPER_ZIP], IWEIGHT_TYPE_POUNDS_LB_OR_KILOGRAMS_KG]) VALUES (@BAG_NUMBER, @CONSIGNEE_ADDRESS_1_STREET_NAME_NO_NUMBERS, @CONSIGNEE_CITY, @CONSIGNEE_COUNTRY_2_LETTER_CODE, @CONSIGNEE_NAME, @CONSIGNEE_PHONE, @CONSIGNEE_ZIP, @CUSTOMER_ORDER_NUMBER, @DESCRIPTION_OF_CONTENTS, @DESTINATION_3_LETTER_AIRPORT_CODE, @NUMBER_OF_PARCELS, @ORIGIN_3_LETTER_AIRPORT_CODE, @PARCEL_TRACKING_NUMBER, @SHIPMENT_NUMBER, @SHIPPER_ACCOUNT_NUMBER, @SHIPPER_ADDRESS_1, @SHIPPER_CITY, @SHIPPER_COUNTRY_2_LETTER_CODE, @SHIPPER_NAME, @SHIPPER_PHONE, @SHIPPER_STATE_2_LETTER_CODE, @SHIPPER_ZIP, @WEIGHT_TYPE_POUNDS_LB_OR_KILOGRAMS_KG)]. Error: Unable to retrieve columns for table aShipment].
b2023-07-10T16:25:14.632] 6Error] rDRIVER] 2023-07-10T16:25:14.632+01:00 0 Unable to retrieve columns for table aShipment].

 

 

So “Unable to retrieve columns for table oShipment]” is the error I get.

 

Running this on the SQL Server solved the issue

 

ALTER SCHEMA dbo TRANSFER RMYDOMAIN\MYUSERNAME].]Shipment];


Reply