The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Creating Remote Database Error
Posted: 16 Nov 07 11:49 AM
|
Hi.
My name is Patty,
Please if somebody can help me, I am creating a remote database but Appear the following Errors.
[16/11/2007 12:36:38]Warning : The table "SALESORDER" exists in the database but not in RESYNCTABLEDEFS and will not be copied.
[16/11/2007 12:36:38]Warning : The table "SALESORDERITEMS" exists in the database but not in RESYNCTABLEDEFS and will not be copied.
[16/11/2007 12:36:38]Warning : The table "tmp_resumen_cartera_slx" exists in the database but not in RESYNCTABLEDEFS and will not be copied.
in the database.
[16/11/2007 12:36:38]Warning : The table "tmp_resumen_cartera" appears in RESYNCTABLEDEFS but does not exist in the database.
Database creationfailed : Invalid table name
Please, someone can tell me What can I do??
Thanks
 |
|
|
|
Re: Creating Remote Database Error
Posted: 16 Nov 07 6:13 PM
|
Patty:
This is failing because the tmp_resumen_cartera table apparently was created with the Database Manager and Dropped via SQL.
You should remove any reference to it from the RESYNCTABLEDEFS and the SECTABLEDEFS table and it will allow you to cut the Database.
Also, if you need the SALESORDER and SALESORDERITEMS tables to be created on the Remot DB and Syncrhonized, then you need to drop them and create them with the DB Manager inside SLX.
|
|
|
|
Re: Creating Remote Database Error
Posted: 17 Nov 07 8:12 AM
|
I believe the DB Manager should initialize the tmp_resumen_cartera table so you should be able to delete it there and it'll safely remove all references. I haven't tested removing a database from SQL to verify that though, but the DB Manager is usually not stingy about what it lists.
Funny thing about the SalesOrder and SalesOrderItem tables. They should have been created by a service pack bundle back in 6.2.x. It should have at least been caught in an upgrade bundle or the 7.x base database. This is usually a red flag for me to double check bundles to make sure everything applied correctly. If no data exists in those tables you can drop them and use the bundle to recreate them. If data exists I'd usually export/re-import it back into the same table(s). |
|
|
|
Re: Creating Remote Database Error
Posted: 19 Nov 07 8:44 AM
|
Hi.
Thanks, I did that you said, and all are good now.
But I have a question, When We create a table in DataBase Manager in SalesLogix, this inserts records in Resynctabledefs,SecTableDefs (and if exists joins in JoinData)...
But if I create a table via SQL, and then insert the information about the table via Sql in that 3 tables...
Could I Have problems with table in the future?
Or what can I Do to view a Table created via SQL in Saleslogix(without dropping and creating it again)??
I hope for your help
Thanks
PD. Sorry by the composition, I'm not good English writer... I'm from Ecuador
 |
|
|
|
Re: Creating Remote Database Error
Posted: 20 Nov 07 6:25 AM
|
In order to do what you want (Create a "SalesLogfix" table via SQL).. you need to fully inderstand what is going on inside these meta-data tables (ResyncTableDefs, SectableDefs, joindata, AND SecProfiles - data blobs)... Yes.. you missed one.. SecProfiles.. and it has an "encoded" data blob that controls FLS (field level security).. break this.. and you break the FLS for the entire system.
The info on these tables is NOT published anywhere and is subject to change ANYTIME by Sage SalesLogix development.. in fact, they have made subtle changes to these tables over time..
Forget going down this path.. it's a waste of time and effort.
--
rjl |
|
|
| |
|
Re: Creating Remote Database Error
Posted: 21 Nov 07 9:33 AM
|
Welcome...
What you can do is "play games" using bundling....
When a table is bundled an then added to a system, everything will be correct in the target system even if the original (source) db is messed up.
Does this help you?
--
rjl |
|
|
|