Remote database creation fails on duplicat object

[pjames95003]

Hi,

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.

Patrick

[RJLedger]

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. 

[pjames95003]

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.

Patrick

[RJLedger]

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... 

Try

  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) 

[pjames95003]

Thanks RJ,

Shows null for the KEYFIELD.  Running this by the integrator now to see if they tried that or not.

Patrick

[RJLedger]

Cannot be NULL.. you just need to run a simple SQL update statement.. suggest via ExecuteSQL in the SalesLogix admin.