Check all security and GUAPAGE too
Java, SpringBoot, React, Angular, Oracle, PL/SQL, Ellucian Banner, Puppet, Docker, Terraform technical notes
Thursday, June 28, 2018
Banner 9: able run form in local but not in server. On server error is Not not authorized access Form
Banner 9: able run form in local but not in server. On server error is Not not authorized access Form
Check all security and GUAPAGE too
Check all security and GUAPAGE too
Wednesday, June 20, 2018
Banner: Cache issues when using Tomcat 8.x in an Eclipse development environment
Banner: Cache issues when using Tomcat 8.x in an Eclipse development environment
Testing Banner 9.x admin pages in an Eclipse development with Tomcat 8.x can result in problems with page data being cached. Due to known Eclipse bugs, the "Serve modules without publishing" flag must be unchecked or Tomcat 8.x will not start up. With that flag unchecked, users have reported annoying cache issues with changes not being picked up when testing. Sometimes clearing the web browser cache manually or doing Tomcat -> Clean and Tomcat -> Clean Tomcat Work Directory will fix the issue, but not always. The suggested work around is to switch to Tomcat 7.x for all testing done via Eclipse. Once development work has been finished, the extensions and custom pages can later be deployed on a Tomcat 8.x server (outside of Eclipse) if desired.
Banner: Eclipse caching old code
Banner 9: Eclipse caching old code
solution:
- close eclipse
- open eclipse
- refresh project
- refresh Webservice. HR
- maven update clean project
sometime need to to twice
solution:
- close eclipse
- open eclipse
- refresh project
- refresh Webservice. HR
- maven update clean project
sometime need to to twice
Banner 9: Add Where clause into SQL query runtime
Banner 9: Add Where clause into SQL query runtime
@BeforeQuery
public void fzvacct_BeforeQuery(QueryEvent args) {
NString acctCode = this.getFormModel().getKeyBlock().getAcctCode();
if (acctCode != null && !acctCode.isEmpty()){
((IDBBusinessObject)args.getSource()).setWhereClause("ACCT_CODE = '"+acctCode+"' ");
}
}
@BeforeQuery
public void fzvacct_BeforeQuery(QueryEvent args) {
NString acctCode = this.getFormModel().getKeyBlock().getAcctCode();
if (acctCode != null && !acctCode.isEmpty()){
((IDBBusinessObject)args.getSource()).setWhereClause("ACCT_CODE = '"+acctCode+"' ");
}
}
Banner 9: Fix tab issue
Banner 9: Fix tab issue
Solution:
Add NextItem into structure file and items should be same block
ex
<Item CanvasName="FFRMASF_4_CANVAS" Id="FFRMASF_ACTV_CODE_LBT" MaxLength="4" Navigable="false" Type="Button" NextItem="FFRMASF_AMT" />
OR
@ActionTrigger(action="KEY-NEXT-ITEM", item="LOCN_CODE_RESP", function=KeyFunction.NEXT_ITEM)
public void ffbmastLocnCodeResp_keyNexItem()
{
goBlock("xxxx");
goItem(toStr("ROOM_NUM"));
getTask().getGoqrpls().gCheckFailure();
}
Solution:
Add NextItem into structure file and items should be same block
ex
<Item CanvasName="FFRMASF_4_CANVAS" Id="FFRMASF_ACTV_CODE_LBT" MaxLength="4" Navigable="false" Type="Button" NextItem="FFRMASF_AMT" />
OR
@ActionTrigger(action="KEY-NEXT-ITEM", item="LOCN_CODE_RESP", function=KeyFunction.NEXT_ITEM)
public void ffbmastLocnCodeResp_keyNexItem()
{
goBlock("xxxx");
goItem(toStr("ROOM_NUM"));
getTask().getGoqrpls().gCheckFailure();
}
Friday, June 1, 2018
Ellucian Banner 9: Disable Save function
Banner 9: Disable Save function
- - comment out Save event in controller
Banner 9 Admin: Error Invalid Object Name fix
Banner 9 Admin: Invalid Object Name fix
do steps:
A record in GUBOBJS with a UI Version of D.
• Records in GURAOBJ to define the default rule and the version and add the page to a Banner Security
Class, such as BANNER_GENERAL_C.
• Insert the page into GUBPAGE, you can use the form GUAPAGE. The GUBPAGE_GUBMODU_CODE
should be the one for the product admin pages.
• Insert Menu XML in the Banner Administrative Page Common common-libraries project, Main.Menu.Def.xml
file. The entry in the menu xml allows you to run the page without Application Navigator.
Insert a menuEntry for the new page so it can be run outside of Application Navigator:
Insert into BANSECR.GURUOBJ (GURUOBJ_OBJECT, GURUOBJ_ROLE, GURUOBJ_USERID, GURUOBJ_ACTIVITY_DATE, GURUOBJ_USER_ID)
Values ('Form Name....', 'BAN_DEFAULT_M', 'banner login user....', SYSDATE, 'BANSECR_NUTTCS');
do steps:
A record in GUBOBJS with a UI Version of D.
• Records in GURAOBJ to define the default rule and the version and add the page to a Banner Security
Class, such as BANNER_GENERAL_C.
• Insert the page into GUBPAGE, you can use the form GUAPAGE. The GUBPAGE_GUBMODU_CODE
should be the one for the product admin pages.
• Insert Menu XML in the Banner Administrative Page Common common-libraries project, Main.Menu.Def.xml
file. The entry in the menu xml allows you to run the page without Application Navigator.
Insert a menuEntry for the new page so it can be run outside of Application Navigator:
Insert into BANSECR.GURUOBJ (GURUOBJ_OBJECT, GURUOBJ_ROLE, GURUOBJ_USERID, GURUOBJ_ACTIVITY_DATE, GURUOBJ_USER_ID)
Values ('Form Name....', 'BAN_DEFAULT_M', 'banner login user....', SYSDATE, 'BANSECR_NUTTCS');
Subscribe to:
Posts (Atom)
AWS how to delete VPC when it has error with Network interface , Gateway decencies
how to delete VPC when it has error with Network interface , Gateway decencies in AWS 1. Check if it is running on EC2 instance then Sto...
-
ORA-29273: HTTP request failed ORA-06512: at "SYS.UTL_HTTP", line 1525 ORA-29261: bad argument ORA-29273: HTTP request failed ...
-
Banner 9 Admin: Invalid Object Name fix do steps: A record in GUBOBJS with a UI Version of D. • Records in GURAOBJ to define the defau...
-
chown root $ORACLE_HOME/bin/extjob chmod 4750 $ORACLE_HOME/bin/extjob chown root $ORACLE_HOME/rdbms/admin/externaljob.ora chmod 640 $ORA...