Ellucian ODS

ODS

SR #: CMS-3468787

4/13/2005 - 5/13/2005

Summary: Finance and HR refreshes not completing. No errors in reports, and the messages say process ended,

Description: Finance and HR refreshes not completing. No errors in reports, and the messages say process ended, but they appear as still running. This is precluding subsequent refreshes from running.

SR #: CMS-3476413

5/20/2005 - 6/15/2005

Summary: UPDATEMFTGENERAL_LEDGER Error Msg: ORA-01536: space quota exceeded for tablespace 'INDX'

Description: Sorry. Apparently I did not repsond to this. Giving IA_ADMIN the
RESOURCE role did not make a difference. We are still getting the
following error...

SR #: CMS-3494890

8/17/2005 - 8/29/2005

Summary: data element "verificationcompletedate" in FINAIDAPPLICANTSTATUS isn't being populated.

Description: Verification complete date is not populated. The data dictionary shows a definition but not a source. Is this a bug, dicontinued, or planned for a future release? RORSTATVERDATE would seem to be the most likely source.

SR #: CMS-3507175

10/12/2005 - 10/19/2005

Summary: field commitmenttype in the encumbrance view is not getting populated.
Description: field commitment
type in the encumbrance view is not getting populated. Would you please advise if this an error or future option? I could not find it in the metadata.

SR #: 1-12248776

12/22/2005 - 5/14/2007

Summary: Column ACADEMICSTANDING from view ASACADEMIC_STUDY comes from SGBSTDN rather than from SHRTTRM.

Description: The ACADEMICSTANDING is being populated from SGBSTDNASTDCODE which is only populated when the academic standing is overridden. There is an end of term academic standing on SHRTTRM which should populate for all records. The SGBSTDNASTD_CODE data does not give a true picture of all student's academic standing.

SR #: 1-12248749

12/22/2005 - 4/30/2007

Summary: SECTRANSCRIPTRECEIVED_DATE not populated.

Description: The SECTRANSCRIPTRECEIVEDDATE field is not being populated in the MSTPRESTUDENT table in the ODS. In the ASPRESTUDENT view, the tables being used include SORHSCH which contains the SORHSCHTRANSRECVDATE. Instead of using the to_date(NULL), perhaps this date could be added to the script.

SR #: 1-12255051

12/23/2005 - 4/30/2007

Summary: There are several fields not being populated in MSTCOURSEOFFERING in the ODS.

Description: There are several fields not being populated in MSTCOURSEOFFERING in the ODS: College, Department, Studentmeetingtime. It appears to be using SSBOVRR which is an override table. College and department information are in SCBCRSE. Meeting time should come from SSRMEET.

SR #: 1-21996153

3/1/2006 - 7/28/2006

Summary: ORA-00001: unique constraint (ODSMGR.MSTSTUDENTCLASSINDEX01) violated.

escription: Prior to upgrading to 2.2, the refresh of student usually took just over 1 hour. Now it is taking over 8 hours. We are also getting the following errror:

Error Msg: ORA-00001: unique constraint (ODSMGR.MSTSTUDENTCLASSINDEX01) violated.

SR #: 1-27218731

4/14/2006 - 12/11/2007

Summary: MSTACADEMICSTUDY table, field ACADEMICPERIODEND

Description: The incorrect ACADEMICPERIODEND is affecting our enrollment counts in the ODS.

Issue 1:
On the “MSTACADEMICSTUDY” table the “ACADEMICPERIODEND” is not always set correctly. For example: For an active student on SGBSTDN with effective term ‘200505’ who was enrolled in ‘200508’ and ‘200601’ the “ACADEMICPERIODEND” on the “MSTACADEMICSTUDY” table is ‘200505’. The “ACADEMICPERIODEND” should be ‘999999’. The '200505' record is their only record. The “PERMITREGISTRATION” flag is set to ‘Y’. The “SGBSTDNSTST_CODE” is ‘AS’.

Issue 2:
If a student has multiple effective terms on “SGBSTDN”, then on the “MSTACADEMICSTUDY” table the “ACADEMICPERIODEND” is the same as the effective term. It should be the term just prior to the next effective term where academic history exists. We are setting prior “SGBSTDN” records to be “INACTIVE” once a new “SGBSTDN” record is created (not sure if this might be the reason).

SR #: 1-109695831

3/13/2007 - 4/13/2007

Summary: Cannot move IA User Administrator Interface to another server.

Description: We need to move the IA User Administrator Interface to another server.

On the new server, we have created a Data Access Descriptor pointing to the current ODS database. We then copied the all the files under the htdocs directory on the old server to the new server. Is there anything else we need to do?

Currently we can login using the new server, but only after a workaround...

SR #: 1-174258471

10/10/2007 - 11/6/2007

Summary: ODS Migration

Description: We have the following scenario: our production is currently on ODS Release 2.1. Our goal is to do a complete (new) fresh install of ODS (Release 3.1). During this process, we would like to migrate our current ODS to point to a different database instance. How can we go about doing this task? How can one migrate an ODS?

I was unable to find any suggestions on this in any of the support sites, including the ODS listserv.

SR #: 1-175539281

10/16/2007 - 11/9/2007

Summary: ODS 2.2: Configuring Metadata after Upgrade

Description: I found an earlier post for configuring metadata after the upgrade to ODS 2.2. According to the post, "defects are introduced with ODS 2.2 which will prevent Metadata from being displayed correctly." The document then goes on to describe how to fix the issue. For example, IF when you go to the InfoAccess Admin UI page > Information Access Options > Setup Parameters: Select Job in the 'Show All Internal Groups' & scroll down to the PUBLISH_METADATA row:

IF the row does not exist, the document suggests that you execute the following script in SQL*Plus as iaadmin:
ODS Home\ia
admin\dbscripts\mtvparmmetadatarecs.sql

*Question: when I go to execute this script with an @ sign preceding the command, I get a file could not be opened message.

SR #: 1-179180281

11/1/2007 - 12/18/2007

Summary: Banner vs. ODS

Description: I have been given a task to compare the tables (and columns, if possible) that exist in both the ODS and our Banner production DB. This will thus pinpoint the tables (and/or columns) that do not exist in the ODS and give our users the ability to let us know what they see 'missing' from the ODS and what we can import, if need-be and if appropriate.

And so: I know that via the ODS Meta Data Reports List (inside the ODS Administrative Web Interface App), one can see the target reports & the source reports. Via this view, one can 'manually' do a comparison of tables/columns that exist in the ODS versus Banner. However, this is quite a tedious task.

Hence: my question consists of: is there a table within a particular schema (in the ODS or in production) that one can query to see the tables that exist in the ODS (target) versus the source. How would I go about writing a query to compare the source tables versus the target tables?

SR #: 1-207896171

3/3/2008 - 3/25/2008

Summary: installing new ods3.1

Description: Instead of upgrading the existing ods2.x, we are installing a new ods3.1.

The 2.x version is still running, so this is not critical, but they would like to switchover to 3.x as soon as possible.

At step 3, importing and deploying owb etl mapping, I am receiving the following error...

SR #: 1-216705321

4/23/2008 - 6/10/2008

Summary: OMB01073: LOCATION ODSMGRLOCATION not found OMB01511: Location ODSMGRLOCATION not found.

Description: I'm having the following problem at step 3 of the install guide...

SR #: 1-225397741

6/11/2008 - 6/24/2008

Summary: LOADMFTTRANS_HISTORY 2 & 3 error: ORA-06502

Description: We are currently being upgraded from ODS 2.2 to ODS 3.1. At the moment, I am attempting to load ODS 3.1. Initially, I made sure to perform the following tasks:
Task 1 - Define General Preferences Address Type
Task 2 - Define Fiscal Years for Transaction History Loads in Finance
Task 3 - Load Finance into the ODS

When performing Task 3, particularly, initially running the LOADMFTTRANS_HISTORY process, the process completed with the status of 'error.'

The following errors exist in the ODS control report:
LOADMFTTRANS_HISTORY2: Error: Map package terminated with Exception.
ORA-06502: PL/SQL: numeric or value error: character string buffer too small...

SR #: 1-227528534

6/24/2008 - 7/22/2008

Summary: Error sending JOB NOTIFICATION Email: ORA-01422: exact fetch returns more than requested number of r

Description: Our init files have been accordingly updated and the prior Oracle 6502 error no longer exists.

Now I am encountering the following error on most of the ODS data loads (although the jobs complete with a status of success):
Error sending JOB NOTIFICATION Email: ORA-01422: exact fetch returns more than requested number of rows.

SR #: 1-233569711

7/29/2008 - 9/5/2008

Summary: Change Table Counter Utility - Refresh Processes?

Description: I ran the change table counter utility on our ODS 3.1.1 instance, to produce a report of the number of rows that are in the source system Change tables for each of the ODS composite tables. This report yielded approximately 20 mappings with row counts of > 0. Hence, for each of the founded 'mappings,' I went ahead and ran a single Update process. After running all of the corresponding update processes, I than ran the Change Table Counter Utility once more, hoping to now get 0 'counts' for all of the mappings. Unfortunately, the exact same 'mappings' are reporting with the exact same record counts (which I thought should have been resolved via the single mapping Update procedures). Is there something broken on our side or is there something that I am missing? Please assist.

SR #: 1-233569713

7/29/2008 - 7/31/2008

Summary: MSTEnrollment versus ASEnrollment

Description: I am comparing MSTEnrollment on our ODS 3.1.1 side, where the count equals 865,892. Then, on the source side (BANINST1 schema > ASEnrollment view), the count for this table, however, is 130,997. Quite a big difference. I ran a refresh process to fix the MSTEnrollment table. Since this didn't do it, I then went ahead and performed the LOADMSTEnrollment process. Finally, since this didn't fix the problem either, I performed a deletemstenrollment and then a loadmst_enrollment (although I believe the load does the delete process in itself). Either way, the counts are still difference. Hence the posting of this question: Is this normal and should this be the case or do we have an issue in our system?

SR #: 1-241455921

9/10/2008 - 10/21/2008

Summary: MSTStudentClassification Discrepancy

Description: On the Banner production side, we have a particular student that is displaying as a Senior. I.e., checking the SGVCLAS view under the BANINST1 schema, this user is classified as a Senior for the latest termcode of 200808. On the ODS side, however, this user is always being displayed as a Junior. For example, for the MSTStudentClassification ODS table, this user has the latest academic period of 200805 (versus 200808). On the Student and Enrollment view (ODS side): the same student is still classified as a Junior, however, in these two views, the student has the latest academic period of 200808. We are currently trying to figure out what is wrong in the process from getting the data from Banner to the ODS (in particular, the mststudent_classification view)? We are hoping that we don't have other students displaying this type of discrepancy...

SR #: 1-242197004

9/15/2008 - 9/17/2008

Summary: RUNREP > WBRTPLATFORM_CONFIG password?

Description: We are in the middle of putting up an ODS 3.1.1 -or- 8.0 test instance. A CSScan was run on our ODS 2.2 production instance and one of the 'lossy errors' for UTF8 conversion is for user/schema RUNREP, table WBRTPLATFORM_CONFIG, and column password. The password here has strange foreign characters. How should we resolve this error? Or should we at all?

SR #: 1-243398241

9/23/2008 - 9/29/2008

Summary: 34 objects invalidated after ods_upgrade to version 8

Description: Please see attachments for details, and help explain why we got so many invalids after the upgrade. My searches have yet to turn up anything. Thanks much for your assistance!

SR #: 1-244448701

9/26/2008 - 10/14/2008

Summary: LOADMFTGRANT_FUND fails

Description: As requested, I am placing this as a separate SR. When running LoadMftGrant_Fund, the mapping fails with: "Mapping Failed. Error retrieving OWB Audit messages."
When logging in to OWB and validating this mapping, I get several errors...

SR #: 1-248314861

10/20/2008 - 11/21/2008

Summary: ODS 8.0 Cognos Packages

Description: QE-DEF-0030 Expression parsing error

SR #: 1-249974561

10/27/2008 - 10/29/2008

Summary: UPDATEMSTPRE_STUDENT error

Description: Upon running our nightly STUDENT REFRESH, the student refresh started to fail a few days ago. When looking at the Control Report via the ODS Administrative Application, the error exists for UPDATEMSTPRE_STUDENT:

Error Msg: ORA-01438: value larger than specified precision allows for this column
Target Name: MSTPRESTUDENT
Target Column: *

Error Msg: ORA-06502: PL/SQL: numeric or value error: number precision too large
Target Name: MSTPRESTUDENT
Target Column: MSTPRE0PSGPA_TRANSFERRE

SR #: 1-250027704

10/28/2008 - 11/18/2009

Summary: Load HR versus Load Student

Description: After setting up our ODS 8.0 test instance, we attempted to run LOAD HR and then LOAD Student. To our surprise, LOAD HR completed successfully after 35 hours and 44 minutes of execution. LOAD STUDENT, on the other hand, completed successfully after 15 hours and 51 minutes of execution. In all of our previous versions of ODS: we have had the opposite experience, where LOAD Student would take the longest (up to 2-3 days). HR, on the other hand, would complete rather quickly. Could you please provide an explanation as to why the LOAD HR takes so much longer than LOAD Student? I would imagine the student load has a lot more tables, etc. to process?

SR #: 1-285806021

2/11/2009 - 2/24/2009

Summary: Missing: AFPURCHASEORDER, AFPURCHASEORDERITEM, AFFIXEDASSETITEM

Description: After the ODS upgrade to ODS 8.0 (we were on ODS 2.2 prior): we are now unable to locate the following ODS views: AFPURCHASEORDER, AFPURCHASEORDERITEM, AFFIXEDASSETITEM. These views do not exist on the Banner side (BANINST1 schema).

SR #: 1-291599794

2/24/2009 - 2/27/2009

Summary: PHRHIST_COMMENT replaced by?

Description: Hello, after our upgrade to Banner 8, we no longer see the PHRHIST_COMMENT column/field in the PHRHIST Banner table. Has this field been replaced by another table? If so, from which table can we now retrieve this field from? We use this field in several of our reports.

SR #: 1-293505551

2/27/2009 - 3/20/2009

Summary: ODS 8.0 MSTSTUDENTCOURSE & MST_GPA tables: slow response time?

Description: Why does the MSTSTUDENTCOURSE table run 3-5 times faster on our ODS 2.2 version, versus the ODS 8.0 version?

SR #: 1-513607331

11/2/2009 - 6/18/2010

Summary: MSTRACESLOT -- empty

Description: OUR MSTRACESLOT table in ODSMGR is empty (not populated). Running the student load and the LOADMSTRACE did not populate this table. How can we get this table populated so that we can use it for reporting purposes.

SR #: 1-651903744

1/26/2010

Summary: ODS82/upgrade/install/required_tablespaces.sql error

Description: Using the login.sql for the ODS 8.2 Install.
EXECUTING SCRIPT: REQUIREDTABLESPACES.SQL FILE: requiredtablespaces.sql
Error running script requiredtablespaces.sql:
ORA-20000: Retrieving source database link terminated with the following
error:ORA-20001: ERROR IN MGKTLIB.F
GETMTVPARMEXTERNALCODE: EXTERNALCODE not found for GROUP: STAGE CONFIGURATION, CODE: SOURCE ALIAS

SR #: 1-666517021

3/9/2010 - 3/31/2010

Summary: Error in LOADGENERAL and REFRESHGENERAL

Description: Error in Control report: ODSMGR.UPDATEMGTEVENT_INVITEE" has errors ORA-06508: PL/SQL: could not find program unit being called

Error on public synonym AGEVENTINVITEE
ORA-01775: looping chain of synonyms

SR #: 1-674951211

3/25/2010 - 3/30/2010

Summary: MSTRACESLOT -- empty

Description: After ODS upgrade to 8.2 from 8.1, the mstraceslot is empty. We had this problem in 8.1 (see 1-513607331) due to patch 1-34UFQ0. We made the change from RACE to RACE Category in mskrace.sql, but after running the load MSTRACESLOT is still empty.

SR #: 1-729045991

6/14/2010

Summary: ODS 8.2 Cognos Package(s)

Description: The sgheodsBv82.zip file that we have on our ODS server is corrupt. We receive the following error when we attempt to extract the file: "...CRC failed in sgheodsbv\model.xml. The file is corrupt." The _DV file extracts just fine. Could you please provide us with a working BV file? Thanks in advance.

SR #: 1-734136051

6/18/2010 - 7/23/2010

Summary: MSTSTUDENTCOURSE ODS discrepancy

Description: We are seeing a large discrepancy between the following two tables:
The MSTSTUDENTCOURSE table in the ODS and the SFRSTCR table in Banner

There are over 2,000 records that do not exist over in our MSTSTUDENTCOURSE table. Running the Student, General, and HR refreshes - does not resolve this issue. The refreshes complete Successfully. Why is it that the MSTSTUDENTCOURSE table is not being updated by our scheduled refreshes?

SR #: 1-739509294

6/23/2010 - 6/25/2010

Summary: ODS 8.2 broken - discrepancies

Description: We are seeing very large ODS discrepancies: i.e., please see our prior request (which should be escalated to Critical).

For the current term (201005): we are also seeing the ODS version of the TBRACCD table having 100,000 rows less than the NFPO table (515,773 vs 415,142).
Many other tables seem to be affected. Please assist us in resolving these issues.

SR #: 1-747532464

7/2/2010 - 8/13/2010

Summary: Refresh Student Error on MSKPRED.P_POPULATE: ORA-01422

Description:
We are receiving an Error on our Student Refreshes:
MSKPRED.P_POPULATE: Slot package error
ORA-01422: exact fetch returns more than requested number of rows

This tells us that in the mapping, a query is expecting one row (doing a SELECT INTO) -- and in our case, the results are more than one row. Hence the error.
Do you have a fix for this?

SR #: 1-817548301

9/1/2010 - 9/23/2010

Summary: ODS/EDW Admin UI in production: Enrollment Management Mappings missing

Description: Looking through our ODS/EDW Administrative Interface for our ODS/EDW production: we do not see the option to load/refresh the Enrollment Management Mappings. This option does exist in our ODS/EDW test UI, however (under Options > Schedule a Process > Schedule Enrollment Management Mappings).

SR #: 1-826894604

9/9/2010 - 9/10/2010

Summary: SFRSTCA rebuild/redeploy capture failure

Description: I have completely redeployed streams in test Banner and test ODS/EDW, specifically for issues encountered rebuilding SFRSTCA in production earlier this summer of 2010.

Capture, propagation and apply all worked fine for this one table after complete redeploy of streams. Once I rebuilt SFRSTCA in Banner source (alter table x move tablespace x), the capture kicked out a warning of:

WARNING: received KRVXOPERCANNOT_SUPPORT
knlldmm: gdbnm=NFTT.WORLD
knlldmm: objn=22784
knlldmm: objv=0
knlldmm: scn=43893625123
knlldmm: opnum=255

SR #: 1-1058576271

1/18/2011 - 1/24/2011

Summary: Student Load; Completing with Errors

Description: While attempting to load the student fraction of the ODS we encounter the following error:

MSKPRED.PPOPULATE Slot package error at: 17-JAN-2011 04:25:22
MSKPRED.P
POPULATE ORA-20000: ORU-10027: buffer overflow, limit of 1000000 bytes
Running Slot Package: MSKREQR.P_POPULATE

SR #: 1-1231562163

3/9/2011 - 4/29/2011

Summary: patch p1-fsyqhv_edw8010112 errors

Description: EDW 8.1.1 patch import/deploy VLD-1134: Invalid location for operator - Configured location for operator does not exist or is not a valid location under the referenced module. - EDWHOLDINPUT "Exception thrown when running mapping: ORA-01403".

SR #: 1-1730432621

6/20/2011 - 7/11/2011

Summary: After moving tables, streams fail

Description: After moving some tables to a different tablespace in preparation for an upgrade. We are receiving the following error.

2011/06/19 07:11 26687 ORA-26687: no instantiation SCN provided for "PAYROLL"."PPRR 1
EFE" in source database "NFPO.WORLD"
ORA-06512: at "SYS.LCR$DDLRECORD", line 256
ORA-06512: at "ODSSTG.MGKSTRH", line 104
ORA-06512: at line 1

SR #: 1-1774514994

6/30/2011 - 7/11/2011

Summary: UPDATEMSTSTUDENT_CLASS Long Run Time

Description: The UPDATEMSTSTUDENT_CLASS mapping alone takes approximately an hour to run for us (nightly), regardless if only 9 records, for example, are being updated -or- as much as 4000 records. We are a bit surprised that 9 records alone take the same time (1 hr+) to run, as 4000 records. Is there some kind of inefficiency in this mapping, that we should be aware of or that we should address? Our ODS version is 8.2.

SR #: 1-1808600141

7/11/2011 - 7/12/2012

Summary: Health Check warning
Description: Question, I am now able to see and access the Staging table and we went ahead and ran the Staging Status Area report. The added tables appear in the STAGED_TABLES list.
However, could you please clarify what the following Warning message means? Is this something we should be concerned about....

SR #: 1-1853898151

7/21/2011 - 8/9/2011

Summary: ORA-01018 errors when running LOAD_HR in ODS-test.

Description: Please assist us in resolving the following errors that we are encountering in our ODS-test instance when running the HR Load.

SR #: 1-1897152591

8/1/2011 - 8/22/2011

Summary: ODS-production Staged Tables not Synchronizing

Description:
Please assist us with the following issue that we are experiencing in our ODS-production instance:
When comparing the Banner replicated tables in the ODS corresponding schemas (i.e., FIMSMGR.FABINVH, FIMSMGR.FARINVA, etc. etc.), we are getting a large number of discrepancies between the Banner source table and the Banner ODS table. The Refresh process doesn't appear to be updating the data properly. We have ran the ODS Stage Status Area report to confirm that the Streams process is working properly. Please see attached supporting documentation.
In attempting to Synchronize the ODS-prod staged tables via the following method, the counts remain the same and discrepancies between Banner source and target continue to exist.
Why is the following Synchronization method not working for us and how should we proceed to Synchronize the ODS staged tables?

SR #: 1-1904152613

8/2/2011 - 8/30/2011

Summary: need to resolve tables out of synch

Description: please see SR #: 1-1897152591 for details.
This has been turned over to DBA; I am unable to work on the existing SR or see existing work that has been done, so would like a new SR to be created.

SR #: 1-1967379321

8/18/2011 - 10/4/2011

Summary: ODS MST_GPA results?

Description: According to the ODS Meta Data, the ODS MST_GPA table key and frequency is as follows:
One row per person per GPA time indicator (time based or not) per GPA group (cumulative or period) per academic study area (level) per GPA type (institution or transfer) per academic period. The above combination should then yield one result.

We, however, have a scenario where the above combination yields two results (versus one) for a particular person/pidm. Does that mean that our ODS MSTGPA table is being utilized/loaded improperly? We have traced the two records to the Student SHRTGPA table. However, the two records for the particular shrtgpagpatypeind, shrtgpapidm, shrtgpalevlcode, and shrtgpatermcode have different results for:
SHRTGPA
TRITSEQNO, SHRTGPAHOURSATTEMPTED, SHRTGPAHOURSEARNED, GPAHOURS, QUALITYPOINTS. The Activity Date is identical.

SR #: 1-2133647071

9/28/2011 - 10/21/2011

Summary: can't enable constraints.

Description: Cleaned up tables and can't enable two constraints; get ORA-02298 errors:
alter table WBRTAUDITPARAMETERS ENABLE constraint APFKAE;
ORA-02298
alter table WB
RTAUDITSTRUCT ENABLE constraint FKRTTRTD;
SQL Error: ORA-02298:

SR #: 1-2272235115

12/12/2011 - 1/13/2012

Summary: Missing columns in destination.

Description: In running the "Stage Area Status" report in our ODS-test instance (note: after the Oracle 11gR2 upgrade), the pstagechecks mapping yields the following error...

SR #: 1-2267890961

12/13/2011 - 1/6/2012

Summary: ODS load performance issues after Oracle 11g upgrade.

Description: We have noticed some performance issues with our ODS-test loads after the Oracle 11gR2 upgrade. For example, the HR Load prior to the 11g upgrade usually took around 20 hours to run to completion. After the Oracle 11gR2 upgrade, the HR Load is now taking 62-63 hours to complete. Likewise, the Student Load usually took 32 hours to complete; after the Oracle 11g upgrade, however, the Student Load has been running for 141+ hours (is in fact still running). Finance Load: usually took 9 hours to complete, now takes about 16 hours to complete; Financial Aid Load: usually took 6 hours to complete, now takes about 12 hours to complete. Have other clients experienced load performance issues after upgrading the ODS source and target to Oracle 11g? Please assist…
(Note: Other data loads are still running/being tested)

SR #: 1-2339037163

1/31/2012 - 2/3/2012

Summary: ORA-1406 in LOG MINER process after upgrading Banner Database from 10.2.0.4 to 11.1.0.7.6

Description: After upgrading Banner database from 10.2.0.4 to 11.1.0.7.6 and leaving ODS database on 10.2.0.4, streams ran fine for ~a day and then stopped with ORA-01406: fetched column value was truncated.

SR #: 1-2467401963

4/23/2012 - 5/4/2012

Summary: Error creating Streams DML rule for FAISMGR.RBBABUD. ORA-01031: insufficient

Description: I cloned our production banner db to a test db and ran : streamssourceclone_script.sql for our ods streams process as SYS, per FAQ 1-TMHHGC and received the following error...

SR #: 1-2476006323

4/27/2012 - 5/4/2012

Summary: I was executing sqlplus /nolog @odsupgrade80201.sql and had the following errors

Description: I was upgrading our ODS 8.2 to 8.2.1 and ran into this problem...

SR #: 1-2489675941

5/4/2012 - 6/8/2012

Summary: ODS 8.2.1 Reload failing after Upgrade

Description: Following the upgrade of our test ODS environment to 8.2.1, I am encountering an error when attempting to run the "Reload ODS 8.2.1 Data":

LOADMATPLEDGE ORA-20001: Exception thrown when running mapping: ORA-04067: not executed, package body "ODSMGR.LOADMATPLEDGE" does not exist ORA-06508: PL/SQL: could not find program unit being called:
LOADMATPLEDGE "ODSMGR.LOADMATPLEDGE"

SR #: 1-2552021141

6/7/2012 - 6/17/2012

Summary: ODS 8.2.1 Missing columns in MetaData & in Reporting View Warnings (Enrollment Management)

Description: We've upgraded our test system from ODS 8.2 to ODS 8.2.1. The pre-req patch of 1-O43S1Z was applied and the new “Reload Utility (v6)” Utility was installed.

In running the ODS Health Check, we are receiving the following warnings in relation to Banner Enrollment Management (RAP). Please help us to resolve these warnings.

SR #: 1-2563517981

6/14/2012 - 7/20/2012

Summary: ODS Descriptions for Code Values - APPLSUPLDATA_0x dups

Description: When going to the ODS > "Maintain Descriptions for Code Values" > Choosing Data Element "APPLSUPLDATA_01" for example, we see duplicates. However, when we attempt to delete one of the Code Descriptions, although the delete says it is successful, indeed the delete does not commit. Why is this not working for us?

SR #: 1-2565162138

6/15/2012 - 6/18/2012

Summary: ODS Health Check "parameter record" warnings

Description: When running the ODS Health Check, we are receiving the following warnings. Please help us resolve these for our ODS 8.2.1 instance. We have confirmed that indeed an MTVPARM record is missing for the %MSTGENERALSTUDENTTRM mappings, however, the two mappings are also showing as invalid in the ODSMGR schema. Have these mappings perhaps been deprecated along the way? The LOADMGTVALIDATIONADVANC mapping package, however, is rendering as valid, yet the parameter record indeed is not found in the IAADMIN.MTVPARM table. Please assist.

SR #: 1-2567672295

6/18/2012 - 7/20/2012

Summary: ODS Health Check type/length mismatch

Description: Greetings, please help us to resolve the following Warnings that we are currently receiving in running the ODS Health Check (version 8.2.1)...

SR #: 1-2701696781

9/11/2012 - 10/5/2012

Summary: ORA-26766: Unexpected redo pattern encountered by LogMiner

Description: In our production ODS we are getting the following error...

SR #: 1-2706487382

9/14/2012 - 10/5/2012

Summary: Need steps to be reviewed on how to drop and recreate a Banner table faismgr.rorstat

Description: Please review the attached document.

SR #: 1-2721909461

10/2/2012 - 10/10/2012

Summary: p1-17ccfl8_ods80200 - An unknown Deployment error

Description: This SR references the following SR, which has been escalated, since the issue also exists in our production environment. (SR # 1-2720743241)

SR #: 1-2754540111

10/29/2012 - 11/13/2012

Summary: Load MSTAdmissionsRequirement error

Description: We are currently receiving an error in our ODS 8.2.1 production instance, After upgrading our ODS production from 8.2 to 8.2.1, we are seeing a new error during the student load on the following mapping:

Loadmstadmissionsrequirement
Error Msg: ORA-12899: value too large for column "ODSMGR"."MST
ADMISSIONSREQUIREMENT"."REQUIREMENTCOMMENT" (actual: 31, maximum: 30) (Next error)

SR #: 1-2810419581

12/10/2012 - 1/20/2013

Summary: Load Transaction History not loading in Dev environment.

Description: We are currently on ODS version 8.2.1. For some reason, in our ODS development environment, when running the LOAD Transaction History, the process completes in 18 seconds and never loads any records. Can you help us troubleshoot as to why this is so? Are we missing something on the Banner dev source or target? Perhaps some paramater? We do not see this occurring in our other environments.

SR #: 1-2902043101

2/12/2013 - 3/4/2013

This SR is Currently Open

Summary: ODS 8.3 preparation.

Description: In preparing to upgrade to ODS 8.3, we have installed Oracle 11gR2 and the necessary components in our ODS test/dev environment. In testing the ODS 8.2.1 version against Oracle 11gR2, we are currently encountering an error on the following mapping. In order to move forward with the actual ODS BI upgrade now (from 8.2.1 to 8.3), we need to resolve this error first. Please assist us in resolving this error.

EDW

SR #: 1-674343283

3/24/2010 - 4/1/2010

Summary: missing Options links on Admin User Interface

Description: The following Options links appear in our dev environment, But Not in our Prod environment.

Maintain Descriptions for Code Values
Translate Code Values from Source Data
List Events for a Banner EDW Star

SR #: 1-844640274

9/23/2010 - 1/28/2011

Summary: EDW Cleansing Load - duplicate errors/warnings

Description: We keep on encountering the following EDW Cleansing Load errors/warnings in both our ODS/EDW production and test instances. Could you please help us to permanently resolve these issues? Temporarily, we have been going into the IA_ADMIN.MGRCDES table and removing the found duplicates. However, something in our process must be leading to these duplicates in the first place (after each ODS Load and EDW Cleansing Load it appears). We need to get our EDW successfully up and running for end-user testing. Below you will find the types of errors/warnings that we are currently encountering. Please assist. Thanks.

ODS production/test version: ODS 8.2
EDW production/test version: EDW 8.1.1

SR #: 1-910678884

11/5/2010 - 3/3/2011

Summary: p1-dxe15z_edw8010103 patch install errors

Description: I'm seeing errors when running the p1-dxe15zimpdepedw8010103.tcl.

SR #: 1-1619411491

5/17/2011 - 7/19/2011

Summary: EDWBANNERCOMM_WKEYS unique constraint violated.

Description: Please help us to resolve the following error when running the LOADEDWBANNER_COMMUNICATION mapping:

EDWBANNERCOMMWKEYS mapping failed:
ORA-00001: unique constraint (EDWSTG.PK
WTTBANNERCOMM_WKEYS) violated.

SR #: 1-1615857881

5/17/2011 - 6/7/2011

Summary: EDW Cleansing: APPLSUPLDATA Duplicacy.

Description: We have been stuck on this for some time now: Although we have been able to resolve all of our prior EDW cleansing errors, we continue to encounter the following error during our EDW cleansing process in our edw-production environment (EDW version 8.2):

Warning: Duplicate rule for Element: APPLSUPLDATA07 with Value: 3 for Source: 5490 - duplicate count: 2
Warning: Duplicate rule for Element: APPL
SUPLDATA01 with Value: T for Source: 5490 - duplicate count: 2
Warning: Duplicate rule for Element: APPLSUPLDATA01 with Value: G for Source: 5490 - duplicate count: 2
Warning: Duplicate rule for Element: APPL
SUPLDATA02 with Value: K for Source: 5490 - duplicate count: 2
Warning: Duplicate rule for Element: APPLSUPLDATA07 with Value: 0 for Source: 5490 - duplicate count: 2
Warning: Duplicate rule for Element: APPL
SUPLDATA02 with Value: N for Source: 5490 - duplicate count: 2
Warning: Duplicate rule for Element: APPLSUPLDATA07 with Value: 5 for Source: 5490 - duplicate count: 2
Warning: Duplicate rule for Element: APPL
SUPLDATA02 with Value: Y for Source: 5490 - duplicate count: 2
Warning: Duplicate rule for Element: APPLSUPLDATA07 with Value: 4 for Source: 5490 - duplicate count: 2
Warning: Duplicate rule for Element: APPL
SUPLDATA02 with Value: C for Source: 5490 - duplicate count: 2
Warning: Duplicate rule for Element: APPLSUPLDATA02 with Value: F for Source: 5490 - duplicate count: 2
Warning: Duplicate rule for Element: APPL
SUPLDATA02 with Value: M for Source: 5490 - duplicate count: 2
Warning: Duplicate rule for Element: APPLSUPLDATA02 with Value: S for Source: 5490 - duplicate count: 2
Warning: Duplicate rule for Element: APPL
SUPLDATA02 with Value: B for Source: 5490 - duplicate count: 2
Warning: Duplicate rule for Element: APPLSUPLDATA07 with Value: 8 for Source: 5490 - duplicate count: 2
Warning: Duplicate rule for Element: APPL
SUPLDATA02 with Value...

SR #: 1-1850065701

7/19/2011 - 8/30/2011

Summary: EDW Student Refresh takes too long

Description: The EDW Student Refresh takes 30+ hours to complete in our EDW production instance (EDW 8.1.1). We have verified that we set the job to R(Refresh) versus L(Load) nightly, as seen by the ProcessINDIN parameter below.

mgkmap.PRunETLMapSlotsByGroup(2,JOB,'LOADEDWSTUDENT',NULL, 'PROCESSINDIN = R| ACADEMICYEAR_IN = ALL');

In particular, I have outlined the long running mappings within the EDW Student Refresh, one of which takes 16 hours.

Should this refresh be taking this long? Please assist.

SR #: 1-2456513911

4/18/2012 - 5/16/2012

Summary: Index Warnings on HEALTHCHECK
Description: I am currently attempting to load our Production EDW. Our Production ODS is up and running and is currently not experiencing any problems. When running the EDW HEALTH
CHECK utility in our Production ODS/EDW environment, the following warnings are returned:

CHECKINDEXEDW Index PKWFTADMISSIONSAPPLICATION missing from WFTADMISSIONSAPPLICATION
CHECK
INDEXEDW Index PKWFTFINAIDAWDACADPDWKEYS missing from WTTFINAIDAWARDACADPDWKEYS
CHECKINDEXEDW Additional Index PKWTTFINAIDAWDACADPDWKEYS found on WTTFINAIDAWARDACADPD_WKEYS

SR #: 1-2468086831

4/24/2012 - 4/26/2012

Summary: LOAD_CLEANSING Warning
Description: I am attempting to bring up our production EDW after being out of use for some time. I am having difficulty when loading cleansing values. The warning I am seeing is relative to a duplicate rule, but when attempting to find the duplicate in the Administrative UI I am unable to. The warnings generated are as follows:

Warning: Duplicate rule for Element: APPLSUPLDATA01 with Value: G for Source: 5490 - duplicate count: 2
Warning: Duplicate rule for Element: APPL
SUPLDATA01 with Value: T for Source: 5490 - duplicate count: 2
Warning: Duplicate rule for Element: APPLSUPLDATA02 with Value: A for Source: 5490 - duplicate count: 2
Warning: Duplicate rule for Element: APPL
SUPLDATA02 with Value: B for Source: 5490 - duplicate count: 2
Warning: Duplicate rule for Element: APPLSUPLDATA02 with Value: C for Source: 5490 - duplicate count: 2
Warning: Duplicate rule for Element: APPL
SUPLDATA02 with Value: F for Source: 5490 - duplicate count: 2
Warning: Duplicate rule for Element: APPLSUPLDATA02 with Value: K for Source: 5490 - duplicate count: 2
Warning: Duplicate rule for Element: APPL
SUPLDATA02 with Value: M for Source: 5490 - duplicate count: 2
Warning: Duplicate rule for Element: APPLSUPLDATA02 with Value: N for Source: 5490 - duplicate count: 2
Warning: Duplicate rule for Element: APPL
SUPLDATA02 with Value: R for Source: 5490 - duplicate count: 2
Warning: Duplicate rule for Element: APPLSUPLDATA02 with Value: S for Source: 5490 - duplicate count: 2
Warning: Duplicate rule for Element: APPL
SUPLDATA02 with Value: T for Source: 5490 - duplicate count: 2
Warning: Duplicate rule for Element: APPLSUPLDATA02 with Value: Y for Source: 5490 - duplicate count: 2
Warning: Duplicate rule for Element: APPL
SUPLDATA07 with Value: 0 for Source: 5490 - duplicate count: 2
Warning: Duplicate rule for Element: APPLSUPLDATA_07 with Value: 3 for Source: 5490 - duplicate count: 2
Warning...

SR #: 1-2920081625

2/21/2013 - 3/4/2013

SR Ongoing

Summary: Report Execution in Cognos from EDW Data Source

Description: During discussion yesterday with Mike Canterbury from Ellucian, tests against our production EDW via a Ellucian-delivered Cognos report were very slow. The report in question is 'Funnel Status by Diversity Summary'. It should also be noted that while working in Query Studio, adding a single data item from the PM Analyze Enrollment Funnel package caused a delay of a minute or more in some cases.

RAP

SR #: 1-1845886611

7/18/2011 - 8/30/2011

Summary: Creating/publishing the PM Prospective Student Diversity Cubes

Description: When attempting to create/update the PM Prospective Student Diversity Cube and the PM Prospective Student Diversity Cube - Current Academic Period: these two cubes (all other delivered RAP/EM cubes are working fine) fail to create, giving us the following Oracle error:
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

We create/publish the cubes via IBM Cognos Transformer, as documented. The detailed error message:
RQP-DEF-0177 An error occurred while performing operation 'sqlOpenResult' status='-28'.
UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive.
UDA-SQL-0107 A general exception has occurred during the operation "open result".
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

How should we proceed to fix this particular issue in order to successfully create the referenced cubes? The issue appeared all of a sudden this week, when attempting to update the cubes. Prior to, we had no issues with these two cubes. Cube locations/properties were not altered.

SR #: 1-2472456187

4/25/2012 - 3/4/2013

SR Still Open

Summary: Unable to load PM - Prospective Student Diversity Cube

Description: When attempting to execute the buildRAPCubes.bat file in our Cognos environment(Windows Server 2003), the "PM Prospective Student Diversity Cube" and "PM Prospective Student Diversity Cube Current Academic Period" cubes do not build. All other cubes have been built successfully, but these simply hang.