Error CVRJC-0348-8 on Primavera

Posts

A User reported an error on Primavera today and I found the fix on the Oracel support Knowledgebase #Bug 9796699: EVENT CODE: 'CVRJC-0348-8' WHEN ACCESSING PROJECT USERS DIALOG SCREEN.

Run the following on the database..

DECLARE @RC int
DECLARE @pret_val int
DECLARE @pret_msg varchar(4000)
EXECUTE @RC = [PMDB_KTT_Corrupt].[dbo].[usession_clear_logical_deletes] @pret_val OUTPUT ,@pret_msg OUTPUT

GO

delete from PROJSHAR where load_status = 'O' and session_id not in (select session_id from usession) or session_id in (select session_id from usession where delete_session_id is not null);

GO

Everything works fine after that....

Utility to check broken links on a website

Today I brushed off some old tech and downloaded a tool I’d used many years ago (I may even have blogged this before!) to check if the Intranet had any broken links.  That tool was called XENU (http://home.snafu.de/tilman/xenulink.html)
Download it from the website (http://home.snafu.de/tilman/xenulink.html#Download)
Extract the ZIP file and Run the install.exe

Installation

Click Next
Click “I Agree”
Click Next
Select the destination directory and click Next
Click Install

Click Next
Click Finish.

Running a link check

Start the application from the Start menu / Xenu Link Slewth / Xenu
From the menu screen click the “Check URL” button on the far left of the tool bar

In the dialogue box enter the URL you want to check, e.g. https://intranet.mydomain.com.au and uncheck the “Check external links” option, unless you want to check those sites.
Click OK.
Results are shown in a list where each link is tested to make sure it’s working correctly.

Press <CTRL>B to clear the view of everything except broken links.
Keep your eye on the progress using the status bar.

At the end you will see something like this:

Showing one broken link.