Mystery Customer Procedures

Dec 26, 2007 3 Replies

RMS V 1.3flat



After having db issues with a store, the store was rebuilt from HQ. The db passed in testing on internal systems, partner systems and MS systems - failed at store. The db only failed when a trx was tendered out (have checked tender types/zed out, etc.) giving errors relating to customers then followed immediately by a run time 5 shutting down RMS. This store has made some kind of a system change that has placed the non-native procedures into the customer db in their system causing it to fail (store will not share info about the cause of the issue).



Basically - here is what I think has happened: This store has made a system change with PCCharge (this is 1 of 5 stores that process via PCCharge as it is not our company recommended/supported processor).



End result/purpose of post:



1) Has anyone run across these procedures before?
2) I want to know how to blow away the following non-native procedures that are stored on the customer db:

dt_addtosourcecontrol dt_addtosourcecontrol_u dt_adduserobject dt_adduserobject_vcs dt_checkinobject dt_checkinobject_u dt_checkoutobject dt_checkoutobject_u dt_displayoaerror dt_displayoaerror_u dt_droppropertiesbyid dt_dropuserobjectbyid dt_generateansiname dt_getobjwithprop dt_getobjwithprop_u dt_getpropertiesbyid dt_getpropertiesbyid_u dt_getpropertiesbyid_vcs dt_getpropertiesbyid_vcs_u dt_isundersourcecontrol dt_isundersourcecontrol_u dt_removefromsourcecontrol dt_setpropertybyid dt_setpropertybyid_u dt_validateloginparams dt_validateloginparams_u dt_vcsenabled dt_verstamp006 dt_whocheckedout dt_whocheckedout_u



Thank you in advance,


Found these in a db we are having issues with, any ideas?

dt_addtosourcecontrol dt_addtosourcecontrol_u dt_adduserobject dt_adduserobject_vcs dt_checkinobject dt_checkinobject_u dt_checkoutobject dt_checkoutobject_u dt_displayoaerror dt_displayoaerror_u dt_droppropertiesbyid dt_dropuserobjectbyid dt_generateansiname dt_getobjwithprop dt_getobjwithprop_u dt_getpropertiesbyid dt_getpropertiesbyid_u dt_getpropertiesbyid_vcs dt_getpropertiesbyid_vcs_u dt_isundersourcecontrol dt_isundersourcecontrol_u dt_removefromsourcecontrol dt_setpropertybyid dt_setpropertybyid_u dt_validateloginparams dt_validateloginparams_u dt_vcsenabled dt_verstamp006 dt_whocheckedout dt_whocheckedout_u

Oops - I accidentally posted 2xs. I think this is 3rd party based - this one just got a little long winded, so I have the post above just outlining the tables.

Nevermind - I know what I did. I had a bad file xfer.

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required