Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Bronze Super Contributor
Posts: 146
Registered: ‎04-01-2009

Remote database creation fails on duplicat object

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

Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Remote database creation fails on duplicat object

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. 

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Bronze Super Contributor
Posts: 146
Registered: ‎04-01-2009

Re: Remote database creation fails on duplicat object

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

Highlighted
Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Remote database creation fails on duplicat object

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) 

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Bronze Super Contributor
Posts: 146
Registered: ‎04-01-2009

Re: Remote database creation fails on duplicat object

Thanks RJ,

 

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

 

Patrick

Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Remote database creation fails on duplicat object

Cannot be NULL.. you just need to run a simple SQL update statement.. suggest via ExecuteSQL in the SalesLogix admin.
--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Bronze Super Contributor
Posts: 176
Registered: ‎04-28-2009

Re: Remote database creation fails on duplicat object

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?

 

Regards,

Marco

---------------------------
Ambit AG, Switzerland