11/5/2026 10:32:29 PM
|
| |
| 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!
Forum to discuss SQL Server or Oracle database administration related to SalesLogix databases. View the code of conduct for posting guidelines.
|
|
|
|
Database Creation Cancelled
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? |
|
|
|
Re: Database Creation Cancelled
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). |
|
|
|
Re: Database Creation Cancelled
Posted: 11 Jan 10 10:42 AM
|
| Validate you have the correct permissions of sydba, should be database owner but no sa rights... |
|
|
|
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!
|
|
|
|
|
|
|
|