02-08-2010 09:48 AM
We're running 7.2.2 LAN version of SLX. We recently applied a few bundles from our integrator, and now when I try to create remote databases, I get an error towards the end of the database creation that says.....
Step: stpExecSQL_CreateViews returned error: There is already an object named 'Cust_View_Name' in the database.
Package execution stopped.
Database creation cancelled.
Our integrator is working on this, but was curious where the Create Remote is looking when it creates the remote databases. Seems odd that there is a duplicate reference somewhere.
Thanks for any education you can provide.
02-08-2010 10:09 AM
It has a basic templete but does go looping thru the joindata table.. and uses Resynctabledefs/Sectabledefs.
I'd suggest your problem may be located one (or a combo) of those three tables.
02-09-2010 09:59 AM
Thanks for the response RJ. I didn't see anything that jumped out at me, but our integrator came back with this...
After much analysis we found the issue. Apparently you guys have helped to uncover a bug in SalesLogix. It appears as though there is an issue with remote databases and creating global joins to views. The xxx_TARGETS_VIEW had 2 global joins added as part of some of the marketing changes. These joins resulted in the behavior you’re seeing when cutting remote dbs. We’ve logged this as a bug with Sage, but they do not currently have any plans to include a fix in a future hotfix or service pack. For now all we can do is remove the global joins and have users trained on how to create local joins to the view.
02-09-2010 02:43 PM
Actually.. all you should need to do is set a valid value in the KEYFIELD field in RESYNCTABLEDEFS for the "VIEW" that is in question and it should work fine..
This is a KI...
SELECT * FROM sysdba.RESYNCTABLEDEFS WHERE TABLENAME = 'NameOfTheView'
Look to see what is in KEYFIELD.
If you fix it.. do it thru the provider (ex: ExecuteSQL in the Admin)
02-12-2010 09:42 AM
04-09-2014 02:12 AM
Old topic, I know, but I'm running in a similar issue right know with SLX 8.1:
1. Create a view, e.g. named AMBCONTACTTEST with the SQL: SELECT CONTACTID, LASTNAME, FIRSTNAME FROM CONTACT 2. Enable the View in DBManager 3. Create a global join Contact.ContactID > LEFT > AMBCONTACTTEST.ContactID 4. Try to create a remotedb. The following error appears: Step: stpExecSQL_CreateViews returned error: There is already an object named 'AMBCONTACTTEST' in the database.
ResyncTableDefs.KeyField is ContactID. Has someone an idea?