Cube Rebuild

B

Billg_sd

When I attempt to rebuild the cube, it never completes. The following errors
appear in the event viewer:

Warning #1
Component: PjViewMgr
File: C:\Office\dev\project\WebClient\source\server\pjviewmgr\ViewCreator.cpp
Line: 1680
Description: <Description><![CDATA[CHECKPTR(NULL)]]></Description>

Error #1
Component: PjViewMgr
File: C:\Office\dev\project\WebClient\source\server\pjviewmgr\ViewCreator.cpp
Line: 1680
Error Number: 0x8007000e
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>

Error #2
Component: PCSViews
File: ViewsDrop.cls
Line: -1
Description: <Description><![CDATA[Error Information:
Additional Information: An error occured calling
CallViewGenerator(ProjectServer, -1, <ProjectData>
<EntProjectName><![CDATA[resglobal] ]></EntProjectName>
<EntResourceIDList>*</EntResourceIDList>
<EntResourceStartDate>2003-01-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2010-10-12T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20030101</CubeStart><CubeFinish>20101012</CubeFinish><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=psdmsp01</DSOConnection><Server>psdmsp01</Server><CubeDB>prodmsp_cube</CubeDB><CubeDesc>Production</CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>65DCB663-052B-40D0-9CB6-3C462A06A402</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>)]]></Description>

It had been building nightly for about 6 months with no issues. Any thougthts?
 
M

Marc Soester

Hi billg_sd

The easiest way to rectify this issue is to open Analysis services, delete
the Project Server connection, rebuild the cube within PWA, go back to
analysis services
and add the user groups that are allowed to view the cubes.
This should solve your problem
hope this helps
 
B

Billg_sd

Hi Marc,

Thanks for the feedback.
Just a quick question: What do you mean by "delete the PS connection?"

Do you mean remove a cube (project views), all cubes (fact tables too),
other?


Marc Soester said:
Hi billg_sd

The easiest way to rectify this issue is to open Analysis services, delete
the Project Server connection, rebuild the cube within PWA, go back to
analysis services
and add the user groups that are allowed to view the cubes.
This should solve your problem
hope this helps
--
Marc Soester
State Manager: EPM


Billg_sd said:
When I attempt to rebuild the cube, it never completes. The following errors
appear in the event viewer:

Warning #1
Component: PjViewMgr
File: C:\Office\dev\project\WebClient\source\server\pjviewmgr\ViewCreator.cpp
Line: 1680
Description: <Description><![CDATA[CHECKPTR(NULL)]]></Description>

Error #1
Component: PjViewMgr
File: C:\Office\dev\project\WebClient\source\server\pjviewmgr\ViewCreator.cpp
Line: 1680
Error Number: 0x8007000e
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>

Error #2
Component: PCSViews
File: ViewsDrop.cls
Line: -1
Description: <Description><![CDATA[Error Information:
Additional Information: An error occured calling
CallViewGenerator(ProjectServer, -1, <ProjectData>
<EntProjectName><![CDATA[resglobal] ]></EntProjectName>
<EntResourceIDList>*</EntResourceIDList>
<EntResourceStartDate>2003-01-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2010-10-12T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20030101</CubeStart><CubeFinish>20101012</CubeFinish><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=psdmsp01</DSOConnection><Server>psdmsp01</Server><CubeDB>prodmsp_cube</CubeDB><CubeDesc>Production</CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>65DCB663-052B-40D0-9CB6-3C462A06A402</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>)]]></Description>

It had been building nightly for about 6 months with no issues. Any thougthts?
Click to expand...
Click to expand...
 
M

Marc Soester

Hi Billg_sd,

sorry Bill, I wasnt very clear about this. I am refering to the "Catalog" or
"Multidimensional Database connection".
When you open up Analysis Manager, you have a connection to a Server (
Youcan see a Server icon. The description beside is usually
the Server Name).
When you drill down from the server you have "Catalogs" of Cubes. Each
catalog can consist of many cubes. One of this Catalog
is the ProjectServer catalog. I suggest that you delete this catalog, then
rebuilld the Cube in Project Web Access ( this will automatically
generate a new ProjectSever catalog in Analysis Services).
The only outstanding task that you will need to preform is that you need to
add the database role, so that only users with the right
to view the cube have access to it.
I hope that made it a bit clearer. Please let me know if you have additional
questions.
Thanks

--
Marc Soester
State Manager: EPM


Billg_sd said:
Hi Marc,

Thanks for the feedback.
Just a quick question: What do you mean by "delete the PS connection?"

Do you mean remove a cube (project views), all cubes (fact tables too),
other?


Marc Soester said:
Hi billg_sd

The easiest way to rectify this issue is to open Analysis services, delete
the Project Server connection, rebuild the cube within PWA, go back to
analysis services
and add the user groups that are allowed to view the cubes.
This should solve your problem
hope this helps
--
Marc Soester
State Manager: EPM


Billg_sd said:
When I attempt to rebuild the cube, it never completes. The following errors
appear in the event viewer:

Warning #1
Component: PjViewMgr
File: C:\Office\dev\project\WebClient\source\server\pjviewmgr\ViewCreator.cpp
Line: 1680
Description: <Description><![CDATA[CHECKPTR(NULL)]]></Description>

Error #1
Component: PjViewMgr
File: C:\Office\dev\project\WebClient\source\server\pjviewmgr\ViewCreator.cpp
Line: 1680
Error Number: 0x8007000e
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>

Error #2
Component: PCSViews
File: ViewsDrop.cls
Line: -1
Description: <Description><![CDATA[Error Information:
Additional Information: An error occured calling
CallViewGenerator(ProjectServer, -1, <ProjectData>
<EntProjectName><![CDATA[resglobal] ]></EntProjectName>
<EntResourceIDList>*</EntResourceIDList>
<EntResourceStartDate>2003-01-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2010-10-12T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20030101</CubeStart><CubeFinish>20101012</CubeFinish><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=psdmsp01</DSOConnection><Server>psdmsp01</Server><CubeDB>prodmsp_cube</CubeDB><CubeDesc>Production</CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>65DCB663-052B-40D0-9CB6-3C462A06A402</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>)]]></Description>

It had been building nightly for about 6 months with no issues. Any thougthts?
Click to expand...
Click to expand...
Click to expand...
 
B

Billg_sd

Hi Marc,

I followed your directions exactly.

Error#1
File: C:\Office\dev\project\WebClient\source\utility\pjadorsutil2.cpp
Line: 317
Error Number: 0x80040e14
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>

Error #2
Component: PjViewMgr
File: C:\Office\dev\project\WebClient\source\server\pjviewmgr\ViewCreator.cpp
Line: 1661
Error Number: 0x80040e14
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>

Error #3
Component: PjQuery
File: C:\Office\dev\project\WebClient\source\server\pjquery\CnxCookie.cpp
Line: 1061
Error Number: 0x80040e14
Description: <Description><![CDATA[Assert Detected for Virtual Root
'ProjectServer'. The error code was also included.]]></Description>

Error #4
Component: PjViewMgr
File: C:\Office\dev\project\WebClient\source\server\pjviewmgr\ViewCreator.cpp
Line: 1506
Error Number: 0x80040e14
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>

Error #5
Component: PCSViews
File: ViewsDrop.cls
Line: -1
Description: <Description><![CDATA[Error Information:
Additional Information: An error occured calling
CallViewGenerator(ProjectServer, -1, <ProjectData>
 
M

Marc Soester

Hi Bill,

can you please check if Project Server has re-created the OLAP catalog?
Thanks
Marc
 
B

Billg_sd

Good Morning Marc,

No - It never recreated the OLAP Catalog. It looks as if it fails within a
minute after starting.

Marc Soester said:
Hi Bill,

can you please check if Project Server has re-created the OLAP catalog?
Thanks
Marc
--
Marc Soester
State Manager: EPM


Billg_sd said:
Hi Marc,

I followed your directions exactly.

Error#1
File: C:\Office\dev\project\WebClient\source\utility\pjadorsutil2.cpp
Line: 317
Error Number: 0x80040e14
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>

Error #2
Component: PjViewMgr
File: C:\Office\dev\project\WebClient\source\server\pjviewmgr\ViewCreator.cpp
Line: 1661
Error Number: 0x80040e14
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>

Error #3
Component: PjQuery
File: C:\Office\dev\project\WebClient\source\server\pjquery\CnxCookie.cpp
Line: 1061
Error Number: 0x80040e14
Description: <Description><![CDATA[Assert Detected for Virtual Root
'ProjectServer'. The error code was also included.]]></Description>

Error #4
Component: PjViewMgr
File: C:\Office\dev\project\WebClient\source\server\pjviewmgr\ViewCreator.cpp
Line: 1506
Error Number: 0x80040e14
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>

Error #5
Component: PCSViews
File: ViewsDrop.cls
Line: -1
Description: <Description><![CDATA[Error Information:
Additional Information: An error occured calling
CallViewGenerator(ProjectServer, -1, <ProjectData>
Click to expand...
Click to expand...
 
M

Marc Soester

that would indicate that the communication between your app server and db
server may have been lost.

do you have the SQL client tools installed ( including the Analysis Server
Manager) on your application. If not please do so and see if you can access
the Analysis Server via the app server. Once you have establised this
connection, please try to rebuild your cube again.
You will need to make sure that you have the correct information within the
Admin tab for PWA in "Manage enterprise features". ( like server name etc.)

Please let me know if this solves the issue.
thanks
Marc
--
Marc Soester
State Manager: EPM


Billg_sd said:
Good Morning Marc,

No - It never recreated the OLAP Catalog. It looks as if it fails within a
minute after starting.

Marc Soester said:
Hi Bill,

can you please check if Project Server has re-created the OLAP catalog?
Thanks
Marc
--
Marc Soester
State Manager: EPM


Billg_sd said:
Hi Marc,

I followed your directions exactly.

Error#1
File: C:\Office\dev\project\WebClient\source\utility\pjadorsutil2.cpp
Line: 317
Error Number: 0x80040e14
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>

Error #2
Component: PjViewMgr
File: C:\Office\dev\project\WebClient\source\server\pjviewmgr\ViewCreator.cpp
Line: 1661
Error Number: 0x80040e14
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>

Error #3
Component: PjQuery
File: C:\Office\dev\project\WebClient\source\server\pjquery\CnxCookie.cpp
Line: 1061
Error Number: 0x80040e14
Description: <Description><![CDATA[Assert Detected for Virtual Root
'ProjectServer'. The error code was also included.]]></Description>

Error #4
Component: PjViewMgr
File: C:\Office\dev\project\WebClient\source\server\pjviewmgr\ViewCreator.cpp
Line: 1506
Error Number: 0x80040e14
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>

Error #5
Component: PCSViews
File: ViewsDrop.cls
Line: -1
Description: <Description><![CDATA[Error Information:
Additional Information: An error occured calling
CallViewGenerator(ProjectServer, -1, <ProjectData>
Click to expand...
Click to expand...
Click to expand...
 
G

Gary L. Chefetz [MVP]

Bill:

I think your problem is that your database contains duplicate key records in
the assignment table. You need to determine which project plans are affected
and delete and reimport them to fix the issue. You should see the 0x80040e14
errors when you attempt to republish an affected plan. This will indicate
which one or ones need deletion therapy.<g>
 
B

Billg_sd

Gary,

I found a culprit. I deleted and re-imported the project. Now when I try
to rebuild the cube, I'm no longer getting the 0x80040e14 error, but instead
get the following errors:

File: C:\Office\dev\project\WebClient\source\utility\pjadorsutil2.cpp
Line: 1691
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>

Component: PjViewMgr
File: C:\Office\dev\project\WebClient\source\server\pjviewmgr\ViewCreator.cpp
Line: 1195
Error Number: 0x80004005

etc...
 
G

Gary L. Chefetz [MVP]

Bill:

These indicate authentication issues. Are you certain this is relative to
the cube build?
 
B

Billg_sd

Oops. Sorry Gary. It was just coincidence that I was getting these errors
too when attempting the cube rebuild. The build releated error is as
follows:

ERROR #1
Component: PCSViews
File: ViewsDrop.cls
Line: -1
Description: <Description><![CDATA[Error Information:
Additional Information: An error occured calling
CallViewGenerator(ProjectServer, -1, <ProjectData>
<EntProjectName><![CDATA[resglobal] ]></EntProjectName>
<EntResourceIDList>*</EntResourceIDList>
<EntResourceStartDate>2003-01-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2010-10-12T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20030101</CubeStart><CubeFinish>20101012</CubeFinish><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=psdmsp01</DSOConnection><Server>psdmsp01</Server><CubeDB>prodmsp_cube</CubeDB><CubeDesc>Production</CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>D74727EC-8E70-4232-94D6-F8329230A52D</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>)]]></Description>

ERROR #2
Component: PCSViews
File: ViewsDrop.cls
Line: -1
Error Number: 0x5
Description: <Description><![CDATA[Error Information: Invalid procedure call
or argument
Additional Information: An error occured processing the following view :-

<ViewsDropData>
<ProjectData>
<EntProjectName><![CDATA[resglobal] ]></EntProjectName>
<EntResourceIDList>*</EntResourceIDList>
<EntResourceStartDate>2003-01-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2010-10-12T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20030101</CubeStart><CubeFinish>20101012</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServer;Data
Source=psdmsp01</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=psdmsp01</DSOConnection><Server>psdmsp01</Server><CubeDB>prodmsp_cube</CubeDB><CubeDesc>Production</CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>D74727EC-8E70-4232-94D6-F8329230A52D</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>ProjectServer</OrgGuid>
<BasePath>ProjectServer</BasePath>
<TimeStamp>2006-04-13T08:33:53</TimeStamp>
</ViewsDropData>]]></Description>
 
G

Gary L. Chefetz [MVP]

Bill:

Are there illegal characters used in your Resource Names, or Outline codes?
The 0x5 error often indicates bad data, but not necessarily.




Oops. Sorry Gary. It was just coincidence that I was getting these
errors
too when attempting the cube rebuild. The build releated error is as
follows:

ERROR #1
Component: PCSViews
File: ViewsDrop.cls
Line: -1
Description: <Description><![CDATA[Error Information:
Additional Information: An error occured calling
CallViewGenerator(ProjectServer, -1, <ProjectData>
<EntProjectName><![CDATA[resglobal] ]></EntProjectName>
<EntResourceIDList>*</EntResourceIDList>
<EntResourceStartDate>2003-01-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2010-10-12T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20030101</CubeStart><CubeFinish>20101012</CubeFinish><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=psdmsp01</DSOConnection><Server>psdmsp01</Server><CubeDB>prodmsp_cube</CubeDB><CubeDesc>Production</CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>D74727EC-8E70-4232-94D6-F8329230A52D</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>)]]></Description>

ERROR #2
Component: PCSViews
File: ViewsDrop.cls
Line: -1
Error Number: 0x5
Description: <Description><![CDATA[Error Information: Invalid procedure
call
or argument
Additional Information: An error occured processing the following view :-

<ViewsDropData>
<ProjectData>
<EntProjectName><![CDATA[resglobal] ]></EntProjectName>
<EntResourceIDList>*</EntResourceIDList>
<EntResourceStartDate>2003-01-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2010-10-12T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20030101</CubeStart><CubeFinish>20101012</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServer;Data
Source=psdmsp01</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=psdmsp01</DSOConnection><Server>psdmsp01</Server><CubeDB>prodmsp_cube</CubeDB><CubeDesc>Production</CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>D74727EC-8E70-4232-94D6-F8329230A52D</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>ProjectServer</OrgGuid>
<BasePath>ProjectServer</BasePath>
<TimeStamp>2006-04-13T08:33:53</TimeStamp>
</ViewsDropData>]]></Description>


Gary L. Chefetz said:
Bill:

These indicate authentication issues. Are you certain this is relative to
the cube build?
Click to expand...
Click to expand...
 
B

Billg_sd

Gary,

Problem solved. I restored the ProjectServer DB to my QA box. When I
rebuilt the cube,
I got a different error: Analysis Server Error: Connection to the server is
lost

See http://support.microsoft.com/kb/885426/EN-US/

It was solved in two steps. 1st, I ran the PSComPlus utility and
removed/re-added the accounts for rebuilding the cube.
I also increased the connection timeout in the registry and restarted the
scheduler, then reset the Project Server related services.

Now it works fine.

Thanks again for your help.
 

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 building problem!! 11
Having trouble building OLAP cube 2
Cube build fails, security check failure 11
OLAP CUBE ERROR in Project Server 2003 environment..Need help!!!!! 1
Cube failed - (-2147221492) Unable to save object. 1
OLAP Cube creation errors 4
Cube building doesn't update PS database? HELP! 2
MSPS 2003 OLAP Build Error - 0x8007000e 1

Top