Issue with ProfilesRNS_CallPRNSWebservice.dtsx

[sn...@bsd.uchicago.edu]

Hello --

We've run into an issue with ProfilesRNS_CallPRNSWebservice.dtsx with the job parameter Funding.

Specifically, it's failing on [Profile.Data].[Funding.DisambiguationResults] attempting to insert a Principal Investigator (PrincipalInvestigatorName, 122 chars) into a 100 char column.

Funding ID: U24HG010262

PrincipalInvestigatorName: CARROLL, ROBERT J;GROSSMAN, ROBERT L.;HALL, IRA M;HALL, JENNIFER L;HAUSSLER, DAVID H;PATEN, BENEDICT ;PHILIPPAKIS, ANTHONY

Our DBA has given us three options:

1. Truncate the data in the load procedure
2. Add a where clause to skip records that exceed the  length of the column
3. Expand the size of the target column

Best recommended approach here?

Thanks, Stephan 

[Brown, Nicholas William]

Stephan

 

The easiest approach would be to do option 1. You would simple need to change varchar(max) to varchar(100) on the principalInvestigatorName column of that stored proc and it will truncate the data. The disadvantage of this approach is that you will see the truncated data on the website when you go to the researcher’s page.

 

Option 3 is probably the best way to handle it, you would need to expand the column in the [Profile.Data].[Funding.DisambiguationResults] table, and also in the [Profile.Data].[Funding.Agreement] table. Data is also copied from that column to the RDF, but that is a varchar(max) column, so you shouldn’t get a truncation error there. I don’t think it is copied anywhere else. But I haven’t tested widening that column, so you would want to check all the jobs run correctly after running this/

 

I would avoid option 2. It would be more complex that option 1, and if someone tries to manually add that grant, it will fail for them.

 

Nick

--
You received this message because you are subscribed to the Google Groups "ProfilesRNS" group.
To unsubscribe from this group and stop receiving emails from it, send an email to profilesrns...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/profilesrns/6b0d3db0-c58c-4165-ba80-62f9e188d755n%40googlegroups.com.