Database Partitioning

[Jeremy]

Hi, we are taking a single-server/single-DB development database and
paritioning it across 3 servers/3 DBs to mirror our test environment. There
is a procedure in the NIstallation manual for doing this. During the
process, my DBA received the following errors:

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
NULL
Starting copy...
NULL
629 rows copied.
Network packet size (bytes): 4096
Clock Time (ms.): total 218
NULL

(7 row(s) affected)

bcp "ProjectServerViewDev..MSP_VIEW_PROJ_TASKS_STD" in
C:\temp\fps\MSP_VIEW_PROJ_TASKS_STD.TBL -c -S RKAMS257\FPS_Dev2 -U epmadmin
-P PG_fpsTech -e C:\temp\fps\MSP_VIEW_PROJ_TASKS_STD_IN.ERR
output



---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
NULL
Starting copy...
SQLState = 22005, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Invalid character value for cast
specification
SQLState = 22005, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Invalid character value for cast
specification
SQLState = 22005, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Invalid character value for cast
specification
SQLState = 22005, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Invalid character value for cast
specification
SQLState = 22005, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Invalid character value for cast
specification
SQLState = 22005, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Invalid character value for cast
specification
SQLState = 22005, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Invalid character value for cast
specification
SQLState = 22005, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Invalid character value for cast
specification
SQLState = 22005, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Invalid character value for cast
specification
SQLState = 22005, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Invalid character value for cast
specification
NULL
BCP copy in failed
NULL

(25 row(s) affected)

RKAMS259\FPS_Dev3
ProjectServerWebDev
RKAMS257\FPS_Dev2
ProjectServerViewDev
bcp "ProjectServerWebDev..MSP_VIEW_PROJ_TASKSPLITS" out
C:\temp\fps\MSP_VIEW_PROJ_TASKSPLITS.TBL -c -S RKAMS259\FPS_Dev3 -U epmadmin
-P PG_fpsTech -e C:\temp\fps\MSP_VIEW_PROJ_TASKSPLITS_OUT.ERR
output



---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
NULL
Starting copy...
NULL
21 rows copied.
Network packet size (bytes): 4096
Clock Time (ms.): total 1
NULL

(7 row(s) affected)

bcp "ProjectServerViewDev..MSP_VIEW_PROJ_TASKSPLITS" in
C:\temp\fps\MSP_VIEW_PROJ_TASKSPLITS.TBL -c -S RKAMS257\FPS_Dev2 -U epmadmin
-P PG_fpsTech -e C:\temp\fps\MSP_VIEW_PROJ_TASKSPLITS_IN.ERR
output



---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
NULL
Starting copy...
NULL
21 rows copied.
Network packet size (bytes): 4096
Clock Time (ms.): total 15
NULL

(7 row(s) affected)

RKAMS259\FPS_Dev3
ProjectServerWebDev
RKAMS257\FPS_Dev2
ProjectServerViewDev
bcp "ProjectServerWebDev..MSP_VIEW_RES_CF" out
C:\temp\fps\MSP_VIEW_RES_CF.TBL -c -S RKAMS259\FPS_Dev3 -U epmadmin -P
PG_fpsTech -e C:\temp\fps\MSP_VIEW_RES_CF_OUT.ERR
output