Portfolio Modeler error

P

Peter Jakab

I try to post my problem again, hoping someone had a problem like mine, in a
non English implementation of Proj 2K2.

We cannot create models. After pressing Next on the first page of model
creation, we receive an error like "Unexpected error, see your system
administrator".
After pressing OK on the message, and canceling the creation process, a
record is created in the MSP_WEB_MODELS table, but the record is corrupt.
We have a 2 server environment (srv1: projsrv, STS;srv2: SQL Server,
analyzis services), both having hungarian defaults (operating system,
database: Hungarian CI_AS).

After setting up the modeler to log into file, in the error log I see:

SERVER COMPONENT ERROR occured at 6/24/2003 8:55:00 AM
Error# = -2147213491
Source = mspjwms.CSession
Descr = Error '[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid
object name 'MSP_WEB_MODELS'.' returned by
engGetContextBuffer/engDBSaveModel
Server Component Info:
Component Title = mspjwms
Component AppName = E:\Microsoft Project Server\Bin\MSPJWMS.(EXE or DLL)
Component Version = 10.2002.502
Server Info:
Server UserID = IUSR_Y-PROJSRV
Server Computer = Y-PROJSRV
Client Info:
Calling procedure = /projectserver/Modeling/modeldtl1.asp
Calling Username = Jakab Péter
Procedure Nesting: (1) procedures.
mspjwms.CSession.SaveModelDetails [150]
-----------------------------------------------------
SERVER COMPONENT ERROR occured at 6/24/2003 8:55:00 AM
Error# = -2147220495
Source = mspjwms.DBFunctions
Descr = Connection opened by mspjwms.CSession.SaveModelDetails and
closed by Error handler
Server Component Info:
Component Title = mspjwms
Component AppName = E:\Microsoft Project Server\Bin\MSPJWMS.(EXE or DLL)
Component Version = 10.2002.502
Server Info:
Server UserID = IUSR_Y-PROJSRV
Server Computer = Y-PROJSRV
Client Info:
Calling procedure = /projectserver/Modeling/modeldtl1.asp
Calling Username = Jakab Péter
Procedure Nesting: (2) procedures.
Error handler
mspjwms.DBFunctions.DBCloseConnection
-----------------------------------------------------

The MSP_WEB_MODELS table IS existing, so this must be a bug in code...

Thanks, best regards

Peter
 
S

Stu Futrill

Peter Jakab said:
I try to post my problem again, hoping someone had a problem like mine, in a
non English implementation of Proj 2K2.

We cannot create models. After pressing Next on the first page of model
creation, we receive an error like "Unexpected error, see your system
administrator".
After pressing OK on the message, and canceling the creation process, a
record is created in the MSP_WEB_MODELS table, but the record is corrupt.
We have a 2 server environment (srv1: projsrv, STS;srv2: SQL Server,
analyzis services), both having hungarian defaults (operating system,
database: Hungarian CI_AS).

After setting up the modeler to log into file, in the error log I see:

SERVER COMPONENT ERROR occured at 6/24/2003 8:55:00 AM
Error# = -2147213491
Source = mspjwms.CSession
Descr = Error '[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid
object name 'MSP_WEB_MODELS'.' returned by
engGetContextBuffer/engDBSaveModel
Server Component Info:
Component Title = mspjwms
Component AppName = E:\Microsoft Project Server\Bin\MSPJWMS.(EXE or DLL)
Component Version = 10.2002.502
Server Info:
Server UserID = IUSR_Y-PROJSRV
Server Computer = Y-PROJSRV
Client Info:
Calling procedure = /projectserver/Modeling/modeldtl1.asp
Calling Username = Jakab Péter
Procedure Nesting: (1) procedures.
mspjwms.CSession.SaveModelDetails [150]
-----------------------------------------------------
SERVER COMPONENT ERROR occured at 6/24/2003 8:55:00 AM
Error# = -2147220495
Source = mspjwms.DBFunctions
Descr = Connection opened by mspjwms.CSession.SaveModelDetails and
closed by Error handler
Server Component Info:
Component Title = mspjwms
Component AppName = E:\Microsoft Project Server\Bin\MSPJWMS.(EXE or DLL)
Component Version = 10.2002.502
Server Info:
Server UserID = IUSR_Y-PROJSRV
Server Computer = Y-PROJSRV
Client Info:
Calling procedure = /projectserver/Modeling/modeldtl1.asp
Calling Username = Jakab Péter
Procedure Nesting: (2) procedures.
Error handler
mspjwms.DBFunctions.DBCloseConnection
-----------------------------------------------------

The MSP_WEB_MODELS table IS existing, so this must be a bug in code...

Thanks, best regards

Peter
Click to expand...

Hi

I had the same message with the Portfolio Modeler when I clicked the
'Next' button.
I think the fix for this was as follows ...
In the 'Security' section of SQL Server change the default database
for the users 'ProjectServer' and 'ProjectServerUser', from 'Master'
to 'ProjectServer'.
Hope that Helps.

Stuart.
 
P

Peter Jakab

That's Great, Stuart!

It works! The default DB was the STS database, setting the defaults to
ProjectServer solved the problem!

Thanks a lot,

Best regards

Peter
:)

Stu Futrill said:
"Peter Jakab" <[email protected]> wrote in message
I try to post my problem again, hoping someone had a problem like mine, in a
non English implementation of Proj 2K2.

We cannot create models. After pressing Next on the first page of model
creation, we receive an error like "Unexpected error, see your system
administrator".
After pressing OK on the message, and canceling the creation process, a
record is created in the MSP_WEB_MODELS table, but the record is corrupt.
We have a 2 server environment (srv1: projsrv, STS;srv2: SQL Server,
analyzis services), both having hungarian defaults (operating system,
database: Hungarian CI_AS).

After setting up the modeler to log into file, in the error log I see:

SERVER COMPONENT ERROR occured at 6/24/2003 8:55:00 AM
Error# = -2147213491
Source = mspjwms.CSession
Descr = Error '[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid
object name 'MSP_WEB_MODELS'.' returned by
engGetContextBuffer/engDBSaveModel
Server Component Info:
Component Title = mspjwms
Component AppName = E:\Microsoft Project Server\Bin\MSPJWMS.(EXE or DLL)
Component Version = 10.2002.502
Server Info:
Server UserID = IUSR_Y-PROJSRV
Server Computer = Y-PROJSRV
Client Info:
Calling procedure = /projectserver/Modeling/modeldtl1.asp
Calling Username = Jakab Péter
Procedure Nesting: (1) procedures.
mspjwms.CSession.SaveModelDetails [150]
-----------------------------------------------------
SERVER COMPONENT ERROR occured at 6/24/2003 8:55:00 AM
Error# = -2147220495
Source = mspjwms.DBFunctions
Descr = Connection opened by mspjwms.CSession.SaveModelDetails and
closed by Error handler
Server Component Info:
Component Title = mspjwms
Component AppName = E:\Microsoft Project Server\Bin\MSPJWMS.(EXE or DLL)
Component Version = 10.2002.502
Server Info:
Server UserID = IUSR_Y-PROJSRV
Server Computer = Y-PROJSRV
Client Info:
Calling procedure = /projectserver/Modeling/modeldtl1.asp
Calling Username = Jakab Péter
Procedure Nesting: (2) procedures.
Error handler
mspjwms.DBFunctions.DBCloseConnection
-----------------------------------------------------

The MSP_WEB_MODELS table IS existing, so this must be a bug in code...

Thanks, best regards

Peter
Click to expand...

Hi

I had the same message with the Portfolio Modeler when I clicked the
'Next' button.
I think the fix for this was as follows ...
In the 'Security' section of SQL Server change the default database
for the users 'ProjectServer' and 'ProjectServerUser', from 'Master'
to 'ProjectServer'.
Hope that Helps.

Stuart.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cube build fails, security check failure 11
Cube building problem!! 11
Cube building doesn't update PS database? HELP! 2
Portfolio Modeler 0
MSPS 2003 Portfolio Modeler - Fatal Modeling Server Error 0
Portfolio Modeler Error 6
Having trouble building OLAP cube 2
Cube failed - (-2147221492) Unable to save object. 1

Top