June 29, 2017 Posted in Blogs

What’s the mostly used suggestion by Ellucian Support when you looked for help? Based on my experience, the answer is always “to upgrade to the latest version with all prerequisites”. That’s the answer with which I never satisfied since I believe it’s an excuse for incapability. Am I correct? The answer is yes till I experienced the GJAPCTL report issue on Banner 9.

In Banner 9 environment, I tried to run GJAPCTL report, for instance NBRPOSN, but unfortunately I got “ERROR” There is no saved output for the Process Name/Number in the database.

There was no report output file nbrposn*.lis generated on BANJOBS home directory. The log file was created with error message below:

       Username: ORA-01017: invalid username/password; logon denied
       Username:
       Password: ORA-01005: nul...

June 12, 2017 Posted in Blogs

Migrating Ellucian Banner 8 to Banner 9 is now the biggest project in Higher Education area. Many of universities and colleges are now working hard for this: recruiting the team, organizing the resources, building up new hardware and software platform, and so on.

Yes, upgrading to Ellucian Banner 9 is a very challenging job as it introduces much hardware and software prerequisites before performing function level upgrade.  Those are now widely known: Ellucian Ethos Identity, Application Navigator, Ellucian BEIS SSO Manager, and Ellucian Solution Manager. All of them are required for Banner 9 upgrade. But, where may we get started? The quick answer is Ellucian Solution Manager.

From project management perspective, at the very beginning, we need to create plan, schedule, and upgrade path ...

May 31, 2017 Posted in Blogs

SQL-92 is a milestone in setting up the standards of SQL query language for relational database. In SQL-92, an important feature is to define Information_Schema – a series of read-only views for retrieving database metadata.

Information_Schema is quite useful when porting one SQL-92 compatible database to another, especially when you have large number of backend scripts which involve metadata operations.

Information_Schema may bring lots of convenience when we build up database-driven solutions since usually these solutions use database metadata quite often.

Let’s see which major databases support SQL-92 Information_Schema :

RDBMS	Rank	SQL-92 Compatible	Information_schema
Oracle	1st		Oracle data dictionary: desc dict; Open source project: ora-info-schema
MySQL 5+	2nd		MySQL Info Schem...