slxdeveloper.com Community Forums

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!

Administration Forums - Database Administration
Forum to discuss SQL Server or Oracle database administration related to SalesLogix databases. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Database Administration | New Thread

View: Search:

Author

Thread: Database Creation Cancelled

Lori
Posts: 4

Database Creation Cancelled Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 08 Jan 10 1:19 PM

We recently made some pretty big changes to our SLX database permissions. I'm trying to cut everyone a new database now. Some have gone well. Today though I seem to get the following at the end of every attempt to create a new database:

[1/8/2010 12:34:08 PM]Error in step: sptDtPmp_Copy_USEROPTIONDEF DTS Data Pump Error at Destination for Row number 340. Errors encountered so far in this task: 1.
[1/8/2010 12:34:09 PM]Error in step: sptDtPmp_Copy_USEROPTIONDEF Microsoft Data Transformation Services (DTS) Data Pump The number of failing rows exceeds the maximum specified.
[1/8/2010 12:34:09 PM]Finished step: sptDtPmp_Copy_USEROPTIONDEF
[1/8/2010 12:34:09 PM]Starting step: sptDtPmp_Copy_USERPROFILE
[1/8/2010 12:34:09 PM]Finished step: sptDtPmp_Copy_USERPROFILE
[1/8/2010 12:34:09 PM]Starting step: sptDtPmp_Copy_USERSECFUNCTIONS
[1/8/2010 12:34:09 PM]Finished step: sptDtPmp_Copy_USERSECFUNCTIONS
[1/8/2010 12:34:09 PM]Finished step: sptDtPmp_Copy_USER_ACTIVITY
[1/8/2010 12:34:10 PM]Finished step: sptDtPmp_Copy_SYNCSECTABLES
[1/8/2010 12:34:10 PM]Finished step: sptDtPmp_Copy_ACTIVITY
[1/8/2010 12:34:10 PM]

Step: sptDtPmp_Copy_USEROPTIONDEF returned error: The number of failing rows exceeds the maximum specified. (Microsoft OLE DB Provider for SQL Server (80004005): Unspecified error)

Step: stpExecSQL_CreateIndexes did not execute. See previous error.
Step: stpExecSQL_CreateViews did not execute. See previous error.
Step: stpExecSQL_ExecSqlTask0 did not execute. See previous error.
Package Execution Stopped. Total execution time: 207.5780 sec.
See error description above.
Database connection information:
SourceServer- SERVERNAME
TargetServer- SERVERNAME
AdminUserID- sa
AdminPWD- ****
NewOwnerUserID- sysdba
NewOwnerPWD- ****
[1/8/2010 12:34:11 PM]Detaching remote db...
Database creation cancelled.

Anyone have any ideas what's going on?

[Reply][Quote]

Mike Spragg
Posts: 1226

Re: Database Creation Cancelled Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 09 Jan 10 6:17 AM

Yep, you have an issue with th useroptiondef table - see 1st line. During the data pump it's failing to insert this into the database table on the new remote database. Use SLX Profiler or SQL trace to identify what the error is (the err above unfortunately doesn't tell you). You should be able to then work backward, fix the issue and re-create without error. Also, ensure the remote db isn't too large (there are inbuilt limits of 2Gb/4Gb for MSDE/SQLExpress).

[Reply][Quote]

Martin Rudnick
Posts: 52

Re: Database Creation Cancelled Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 11 Jan 10 10:42 AM

Validate you have the correct permissions of sydba, should be database owner but no sa rights...

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 4/16/2024 2:33:17 AM