Monday, January 27, 2014

eOne Extender - New solutions do not import correctly. Old solutions do not delete properly.

I had experienced problems loading new solutions even after deleting old solutions.
I resolved the issue by running the grant.sql on all databases, and then manually going into the extender tables and deleting any data i found in them pertaining to the old solutions.

Once the tables were cleared out, the new solution imported correctly.

truncate table ext01200
truncate table ext01201
truncate table ext01203
truncate table ext01211
truncate table ext01212
truncate table ext01213
truncate table ext20010
truncate table EXT00900
truncate table EXT10200
truncate table EXT20010
truncate table EXT20021
truncate table EXT20110
truncate table EXT20200
truncate table EXT20400
truncate table EXT20401
truncate table EXT20402
truncate table EXT20403
truncate table EXT20500
truncate table EXT20700
truncate table EXT21000
truncate table EXT21010

No comments:

Post a Comment