Hi guys,

playing with export/import After I imported below appl on a new db instance and double click on the main panel, got the ORA-31050 error. Can't open the panel or source.

The appl works on HR schema as per tutorial. FS ver. 1.8.1, same DB as before.

    <?xml version="1.0" encoding="UTF-8"?>
<BDF BUILD="41"><APPLICATIONS><APPLICATION><NAME_TX>test</NAME_TX><DATASOURCESCHEMA_TX>HR</DATASOURCESCHEMA_TX><USEAPPLICATIONPKG_YN>Y</USEAPPLICATIONPKG_YN><TYPE_CD>Desktop</TYPE_CD><TEAMCODING_YN>Y</TEAMCODING_YN><SOURCECONTROL_YN>Y</SOURCECONTROL_YN></APPLICATION></APPLICATIONS><MAINFRAMES><MAINFRAME><NAME_TX>mainFrame</NAME_TX><WIDTH_NR>500</WIDTH_NR><HEIGHT_NR>500</HEIGHT_NR></MAINFRAME></MAINFRAMES><DIALOGS/><WINDOWCONTENTS><WINDOWCONTENT><MAINFRAMENAME_TX>mainFrame</MAINFRAMENAME_TX><BDF_WINDOWCONTENT_OID>9671</BDF_WINDOWCONTENT_OID><LAYOUTTYPE_CD>BorderLayout</LAYOUTTYPE_CD><INITORDER_NR>1</INITORDER_NR></WINDOWCONTENT><WINDOWCONTENT><MAINFRAMENAME_TX>mainFrame</MAINFRAMENAME_TX><BDF_WINDOWCONTENT_RFK>9671</BDF_WINDOWCONTENT_RFK><BDF_WINDOWCONTENT_OID>9672</BDF_WINDOWCONTENT_OID><LAYOUTTYPE_CD>BorderCell</LAYOUTTYPE_CD><INITORDER_NR>2</INITORDER_NR><DOCKING_CD>Center</DOCKING_CD></WINDOWCONTENT><WINDOWCONTENT><MAINFRAMENAME_TX>mainFrame</MAINFRAMENAME_TX><PANELNAME_TX>mainPanel</PANELNAME_TX><BDF_WINDOWCONTENT_RFK>9672</BDF_WINDOWCONTENT_RFK><BDF_WINDOWCONTENT_OID>9673</BDF_WINDOWCONTENT_OID><INITORDER_NR>3</INITORDER_NR></WINDOWCONTENT></WINDOWCONTENTS><PANELS><PANEL><NAME_TX>mainPanel</NAME_TX><TYPE_CD>Simple</TYPE_CD></PANEL></PANELS><PANELDTLS><PANELDTL><LAYOUTTYPE_CD>TableLayout</LAYOUTTYPE_CD><BDF_PANELDTL_OID>9954</BDF_PANELDTL_OID><PANELNAME_TX>mainPanel</PANELNAME_TX><INITORDER_NR>0</INITORDER_NR><CELLSPACING_NR>5</CELLSPACING_NR></PANELDTL><PANELDTL><LAYOUTTYPE_CD>TableRowCell</LAYOUTTYPE_CD><BDF_PANELDTL_OID>9955</BDF_PANELDTL_OID><BDF_PANELDTL_RFK>9954</BDF_PANELDTL_RFK><PANELNAME_TX>mainPanel</PANELNAME_TX><INITORDER_NR>1</INITORDER_NR></PANELDTL><PANELDTL><LAYOUTTYPE_CD>TableColumnCell</LAYOUTTYPE_CD><BDF_PANELDTL_OID>9956</BDF_PANELDTL_OID><BDF_PANELDTL_RFK>9955</BDF_PANELDTL_RFK><PANELNAME_TX>mainPanel</PANELNAME_TX><INITORDER_NR>2</INITORDER_NR><HALIGN_CD>Full</HALIGN_CD><VALIGN_CD>Full</VALIGN_CD></PANELDTL><PANELDTL><DBOBJECTACCESSUSGNAME_TX>EMPLOYEES11</DBOBJECTACCESSUSGNAME_TX><BDF_PANELDTL_OID>9957</BDF_PANELDTL_OID><BDF_PANELDTL_RFK>9956</BDF_PANELDTL_RFK><PANELNAME_TX>mainPanel</PANELNAME_TX><COMPONENTTYPE_CD>Grid</COMPONENTTYPE_CD><INITORDER_NR>3</INITORDER_NR><EDITABLECOLUMNNAME_TX>EDITABLE</EDITABLECOLUMNNAME_TX><FONTSIZECOLUMNNAME_TX>FONTSIZE</FONTSIZECOLUMNNAME_TX><FONTCOLORCOLUMNNAME_TX>FONTCOLOR</FONTCOLORCOLUMNNAME_TX><FONTFAMILYCOLUMNNAME_TX>FONTFAMILY</FONTFAMILYCOLUMNNAME_TX><FONTSTYLECOLUMNNAME_TX>FONTSTYLE</FONTSTYLECOLUMNNAME_TX></PANELDTL><PANELDTL><LABEL_TX>FIRST NAME</LABEL_TX><BDF_PANELDTL_OID>9958</BDF_PANELDTL_OID><BDF_PANELDTL_RFK>9957</BDF_PANELDTL_RFK><PANELNAME_TX>mainPanel</PANELNAME_TX><COMPONENTTYPE_CD>Column</COMPONENTTYPE_CD><INITORDER_NR>4</INITORDER_NR></PANELDTL><PANELDTL><DATASOURCEDEFATRIBNAME_TX>FIRST_NAME</DATASOURCEDEFATRIBNAME_TX><BDF_PANELDTL_OID>9959</BDF_PANELDTL_OID><BDF_PANELDTL_RFK>9958</BDF_PANELDTL_RFK><PANELNAME_TX>mainPanel</PANELNAME_TX><COMPONENTTYPE_CD>TextField</COMPONENTTYPE_CD><INITORDER_NR>5</INITORDER_NR></PANELDTL><PANELDTL><LABEL_TX>LAST NAME</LABEL_TX><BDF_PANELDTL_OID>9960</BDF_PANELDTL_OID><BDF_PANELDTL_RFK>9957</BDF_PANELDTL_RFK><PANELNAME_TX>mainPanel</PANELNAME_TX><COMPONENTTYPE_CD>Column</COMPONENTTYPE_CD><INITORDER_NR>6</INITORDER_NR></PANELDTL><PANELDTL><DATASOURCEDEFATRIBNAME_TX>LAST_NAME</DATASOURCEDEFATRIBNAME_TX><BDF_PANELDTL_OID>9961</BDF_PANELDTL_OID><BDF_PANELDTL_RFK>9960</BDF_PANELDTL_RFK><PANELNAME_TX>mainPanel</PANELNAME_TX><COMPONENTTYPE_CD>TextField</COMPONENTTYPE_CD><INITORDER_NR>7</INITORDER_NR><TOOLTIPCOLUMNNAME_TX>HIERARCHYTOOLTIP</TOOLTIPCOLUMNNAME_TX></PANELDTL><PANELDTL><LABEL_TX>SALARY</LABEL_TX><BDF_PANELDTL_OID>9962</BDF_PANELDTL_OID><BDF_PANELDTL_RFK>9957</BDF_PANELDTL_RFK><PANELNAME_TX>mainPanel</PANELNAME_TX><COMPONENTTYPE_CD>Column</COMPONENTTYPE_CD><INITORDER_NR>8</INITORDER_NR><COLUMNWIDTH_TX>20%</COLUMNWIDTH_TX></PANELDTL><PANELDTL><DATASOURCEDEFATRIBNAME_TX>SALARY</DATASOURCEDEFATRIBNAME_TX><BDF_PANELDTL_OID>9963</BDF_PANELDTL_OID><BDF_PANELDTL_RFK>9962</BDF_PANELDTL_RFK><PANELNAME_TX>mainPanel</PANELNAME_TX><COMPONENTTYPE_CD>TextField</COMPONENTTYPE_CD><INITORDER_NR>9</INITORDER_NR><BGCOLORCOLUMNNAME_TX>SALARYBGCOLOR</BGCOLORCOLUMNNAME_TX></PANELDTL></PANELDTLS><DBOBJECTACCESSES><DBOBJECTACCESS><DATASOURCEDEFNAME_TX>EMPLOYEES1</DATASOURCEDEFNAME_TX><NAME_TX>EMPLOYEES11</NAME_TX><QUERYONINITIALIZE_YN>Y</QUERYONINITIALIZE_YN><MAXROWFETCH_NR>-1</MAXROWFETCH_NR><GENERATEXML_YN>Y</GENERATEXML_YN><GENERATEPLSQLTABLE_YN>Y</GENERATEPLSQLTABLE_YN><FORCECURRENTROW_YN>N</FORCECURRENTROW_YN><MOVECURRENTROW_CD>none</MOVECURRENTROW_CD></DBOBJECTACCESS></DBOBJECTACCESSES><DBOBJECTBINDVARUSAGES/><PROGRAMUNITS/><ELEMENTEVENTS/><MENUBARS/><POPUPMENUS/><MENUITEMS/><ALERTS/><BUTTONGROUPS/><EXTERNALMETHODS/><RECORDLISTS/><RECORDLISTCOLUMNS/><RECORDLISTSEARCHS/><ARCHIVES/><DATASOURCEDEFBINDVARS/><DATASOURCEDEFATRIBS><DATASOURCEDEFATRIB><DATASOURCEDEFNAME_TX>EMPLOYEES1</DATASOURCEDEFNAME_TX><NAME_TX>DATASOURCEINSTANCE_OID</NAME_TX><DATATYPE_CD>NUMBER</DATATYPE_CD><PRIMARYKEY_YN>N</PRIMARYKEY_YN><CONCURRENCYCOLUMN_YN>N</CONCURRENCYCOLUMN_YN><REQUIRED_YN>N</REQUIRED_YN><UPDATABLE_YN>N</UPDATABLE_YN><TYPE_CD>DataSourceOid</TYPE_CD></DATASOURCEDEFATRIB><DATASOURCEDEFATRIB><DATASOURCEDEFNAME_TX>EMPLOYEES1</DATASOURCEDEFNAME_TX><NAME_TX>BDF_DBOBJECTACCESSINS_OID</NAME_TX><DATATYPE_CD>NUMBER</DATATYPE_CD><PRIMARYKEY_YN>N</PRIMARYKEY_YN><CONCURRENCYCOLUMN_YN>N</CONCURRENCYCOLUMN_YN><REQUIRED_YN>N</REQUIRED_YN><UPDATABLE_YN>N</UPDATABLE_YN><TYPE_CD>DbObjectAccessInstance</TYPE_CD></DATASOURCEDEFATRIB><DATASOURCEDEFATRIB><DATASOURCEDEFNAME_TX>EMPLOYEES1</DATASOURCEDEFNAME_TX><NAME_TX>BDF_DMLORDER_NR</NAME_TX><DATATYPE_CD>NUMBER</DATATYPE_CD><PRIMARYKEY_YN>N</PRIMARYKEY_YN><CONCURRENCYCOLUMN_YN>N</CONCURRENCYCOLUMN_YN><REQUIRED_YN>N</REQUIRED_YN><UPDATABLE_YN>N</UPDATABLE_YN><TYPE_CD>DMLOrder</TYPE_CD></DATASOURCEDEFATRIB><DATASOURCEDEFATRIB><DATASOURCEDEFNAME_TX>EMPLOYEES1</DATASOURCEDEFNAME_TX><NAME_TX>BDF_STATUS_CD</NAME_TX><DATATYPE_CD>VARCHAR2</DATATYPE_CD><LENGTH_NR>30</LENGTH_NR><PRIMARYKEY_YN>N</PRIMARYKEY_YN><CONCURRENCYCOLUMN_YN>N</CONCURRENCYCOLUMN_YN><REQUIRED_YN>N</REQUIRED_YN><UPDATABLE_YN>N</UPDATABLE_YN><TYPE_CD>RecordStatus</TYPE_CD></DATASOURCEDEFATRIB><DATASOURCEDEFATRIB><DATASOURCEDEFNAME_TX>EMPLOYEES1</DATASOURCEDEFNAME_TX><NAME_TX>BDF_SNAPSHOTINS_OID</NAME_TX><DATATYPE_CD>NUMBER</DATATYPE_CD><PRIMARYKEY_YN>N</PRIMARYKEY_YN><CONCURRENCYCOLUMN_YN>N</CONCURRENCYCOLUMN_YN><REQUIRED_YN>N</REQUIRED_YN><UPDATABLE_YN>N</UPDATABLE_YN><TYPE_CD>SnapshotInstance</TYPE_CD></DATASOURCEDEFATRIB><DATASOURCEDEFATRIB><DATASOURCEDEFNAME_TX>EMPLOYEES1</DATASOURCEDEFNAME_TX><NAME_TX>BDF_ORDER_NR</NAME_TX><DATATYPE_CD>NUMBER</DATATYPE_CD><PRIMARYKEY_YN>N</PRIMARYKEY_YN><CONCURRENCYCOLUMN_YN>N</CONCURRENCYCOLUMN_YN><REQUIRED_YN>N</REQUIRED_YN><UPDATABLE_YN>N</UPDATABLE_YN><TYPE_CD>BDFOrder</TYPE_CD></DATASOURCEDEFATRIB><DATASOURCEDEFATRIB><DATASOURCEDEFNAME_TX>EMPLOYEES1</DATASOURCEDEFNAME_TX><NAME_TX>BDF_FILTERED_YN</NAME_TX><DATATYPE_CD>VARCHAR2</DATATYPE_CD><LENGTH_NR>1</LENGTH_NR><PRIMARYKEY_YN>N</PRIMARYKEY_YN><CONCURRENCYCOLUMN_YN>N</CONCURRENCYCOLUMN_YN><REQUIRED_YN>N</REQUIRED_YN><UPDATABLE_YN>N</UPDATABLE_YN><TYPE_CD>BDFFilter</TYPE_CD></DATASOURCEDEFATRIB><DATASOURCEDEFATRIB><DATASOURCEDEFNAME_TX>EMPLOYEES1</DATASOURCEDEFNAME_TX><NAME_TX>SALARYBGCOLOR</NAME_TX><DATATYPE_CD>VARCHAR2</DATATYPE_CD><LENGTH_NR>3</LENGTH_NR><PRIMARYKEY_YN>N</PRIMARYKEY_YN><CONCURRENCYCOLUMN_YN>N</CONCURRENCYCOLUMN_YN><REQUIRED_YN>N</REQUIRED_YN><UPDATABLE_YN>Y</UPDATABLE_YN><TYPE_CD>RegularAttribute</TYPE_CD></DATASOURCEDEFATRIB><DATASOURCEDEFATRIB><DATASOURCEDEFNAME_TX>EMPLOYEES1</DATASOURCEDEFNAME_TX><NAME_TX>FIRST_NAME</NAME_TX><DATATYPE_CD>VARCHAR2</DATATYPE_CD><LENGTH_NR>20</LENGTH_NR><PRIMARYKEY_YN>N</PRIMARYKEY_YN><CONCURRENCYCOLUMN_YN>N</CONCURRENCYCOLUMN_YN><REQUIRED_YN>N</REQUIRED_YN><UPDATABLE_YN>Y</UPDATABLE_YN><TYPE_CD>RegularAttribute</TYPE_CD></DATASOURCEDEFATRIB><DATASOURCEDEFATRIB><DATASOURCEDEFNAME_TX>EMPLOYEES1</DATASOURCEDEFNAME_TX><NAME_TX>LAST_NAME</NAME_TX><DATATYPE_CD>VARCHAR2</DATATYPE_CD><LENGTH_NR>25</LENGTH_NR><PRIMARYKEY_YN>N</PRIMARYKEY_YN><CONCURRENCYCOLUMN_YN>N</CONCURRENCYCOLUMN_YN><REQUIRED_YN>Y</REQUIRED_YN><UPDATABLE_YN>Y</UPDATABLE_YN><TYPE_CD>RegularAttribute</TYPE_CD></DATASOURCEDEFATRIB><DATASOURCEDEFATRIB><DATASOURCEDEFNAME_TX>EMPLOYEES1</DATASOURCEDEFNAME_TX><NAME_TX>SALARY</NAME_TX><DATATYPE_CD>NUMBER</DATATYPE_CD><LENGTH_NR>8</LENGTH_NR><PREC_NR>2</PREC_NR><PRIMARYKEY_YN>N</PRIMARYKEY_YN><CONCURRENCYCOLUMN_YN>N</CONCURRENCYCOLUMN_YN><REQUIRED_YN>N</REQUIRED_YN><UPDATABLE_YN>Y</UPDATABLE_YN><TYPE_CD>RegularAttribute</TYPE_CD></DATASOURCEDEFATRIB><DATASOURCEDEFATRIB><DATASOURCEDEFNAME_TX>EMPLOYEES1</DATASOURCEDEFNAME_TX><NAME_TX>FONTSIZE</NAME_TX><DATATYPE_CD>NUMBER</DATATYPE_CD><PRIMARYKEY_YN>N</PRIMARYKEY_YN><CONCURRENCYCOLUMN_YN>N</CONCURRENCYCOLUMN_YN><REQUIRED_YN>N</REQUIRED_YN><UPDATABLE_YN>Y</UPDATABLE_YN><TYPE_CD>RegularAttribute</TYPE_CD></DATASOURCEDEFATRIB><DATASOURCEDEFATRIB><DATASOURCEDEFNAME_TX>EMPLOYEES1</DATASOURCEDEFNAME_TX><NAME_TX>FONTCOLOR</NAME_TX><DATATYPE_CD>VARCHAR2</DATATYPE_CD><LENGTH_NR>5</LENGTH_NR><PRIMARYKEY_YN>N</PRIMARYKEY_YN><CONCURRENCYCOLUMN_YN>N</CONCURRENCYCOLUMN_YN><REQUIRED_YN>N</REQUIRED_YN><UPDATABLE_YN>Y</UPDATABLE_YN><TYPE_CD>RegularAttribute</TYPE_CD></DATASOURCEDEFATRIB><DATASOURCEDEFATRIB><DATASOURCEDEFNAME_TX>EMPLOYEES1</DATASOURCEDEFNAME_TX><NAME_TX>FONTFAMILY</NAME_TX><DATATYPE_CD>VARCHAR2</DATATYPE_CD><LENGTH_NR>7</LENGTH_NR><PRIMARYKEY_YN>N</PRIMARYKEY_YN><CONCURRENCYCOLUMN_YN>N</CONCURRENCYCOLUMN_YN><REQUIRED_YN>N</REQUIRED_YN><UPDATABLE_YN>Y</UPDATABLE_YN><TYPE_CD>RegularAttribute</TYPE_CD></DATASOURCEDEFATRIB><DATASOURCEDEFATRIB><DATASOURCEDEFNAME_TX>EMPLOYEES1</DATASOURCEDEFNAME_TX><NAME_TX>FONTSTYLE</NAME_TX><DATATYPE_CD>VARCHAR2</DATATYPE_CD><LENGTH_NR>6</LENGTH_NR><PRIMARYKEY_YN>N</PRIMARYKEY_YN><CONCURRENCYCOLUMN_YN>N</CONCURRENCYCOLUMN_YN><REQUIRED_YN>N</REQUIRED_YN><UPDATABLE_YN>Y</UPDATABLE_YN><TYPE_CD>RegularAttribute</TYPE_CD></DATASOURCEDEFATRIB><DATASOURCEDEFATRIB><DATASOURCEDEFNAME_TX>EMPLOYEES1</DATASOURCEDEFNAME_TX><NAME_TX>EDITABLE</NAME_TX><DATATYPE_CD>VARCHAR2</DATATYPE_CD><LENGTH_NR>1</LENGTH_NR><PRIMARYKEY_YN>N</PRIMARYKEY_YN><CONCURRENCYCOLUMN_YN>N</CONCURRENCYCOLUMN_YN><REQUIRED_YN>N</REQUIRED_YN><UPDATABLE_YN>Y</UPDATABLE_YN><TYPE_CD>RegularAttribute</TYPE_CD></DATASOURCEDEFATRIB><DATASOURCEDEFATRIB><DATASOURCEDEFNAME_TX>EMPLOYEES1</DATASOURCEDEFNAME_TX><NAME_TX>HIERARCHYTOOLTIP</NAME_TX><DATATYPE_CD>VARCHAR2</DATATYPE_CD><LENGTH_NR>4000</LENGTH_NR><PRIMARYKEY_YN>N</PRIMARYKEY_YN><CONCURRENCYCOLUMN_YN>N</CONCURRENCYCOLUMN_YN><REQUIRED_YN>N</REQUIRED_YN><UPDATABLE_YN>Y</UPDATABLE_YN><TYPE_CD>RegularAttribute</TYPE_CD></DATASOURCEDEFATRIB></DATASOURCEDEFATRIBS><LANGUAGES/><DOMAINS/><DOMAINDTLS/><DOMAINDTLDSPS/><TIMERS/><TMP/><DATASOURCEDEFS><DATASOURCEDEF><NAME_TX>EMPLOYEES1</NAME_TX><CREATESYNONYM_YN>N</CREATESYNONYM_YN><DELETEALLOWED_YN>N</DELETEALLOWED_YN><INSERTALLOWED_YN>N</INSERTALLOWED_YN><UPDATEALLOWED_YN>N</UPDATEALLOWED_YN><FROMDB_YN>N</FROMDB_YN><SINGLETON_YN>N</SINGLETON_YN><QUERY_CL><VALUE_CL><![CDATA[select e.first_name
      ,e.last_name
      ,e.salary
      ,decode(connect_by_isleaf, 1, 'Y', 'N') as editable
      ,decode(connect_by_isleaf, 1, 10, 12) as fontSize
      ,decode(connect_by_isleaf, 1, 'Green', 'Navy') as fontColor
      ,decode(connect_by_isleaf, 1, 'Arial', 'Courier') as fontFamily
      ,decode(connect_by_isleaf, 1, 'Italic', 'Bold') as fontStyle
      ,'Employee Hierarchy: ' || sys_connect_by_path(last_name, '/') as hierarchyTooltip
      ,case when salary >= 3000 then null else 'Red' end as salaryBGColor
from employees e
start with e.manager_id is null
connect by e.manager_id = prior e.employee_id
order siblings by e.first_name, e.last_name]]></VALUE_CL>
</QUERY_CL><WHERE_CL><VALUE_CL/>
</WHERE_CL><ORDERBY_CL><VALUE_CL/>
</ORDERBY_CL></DATASOURCEDEF></DATASOURCEDEFS></BDF>

Advice?

Regards

Dean

asked 17 Apr '15, 04:22

downunder's gravatar image

downunder
612
accept rate: 0%

edited 17 Apr '15, 04:27


Hi,

Your example worked on our environment. So we are having difficulties in replicating the problem.

Kind Regards,
Yalim

link

answered 07 May '15, 10:12

Yalim%20Gerger's gravatar image

Yalim Gerger ♦♦
1.8k5
accept rate: 15%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×1

Asked: 17 Apr '15, 04:22

Seen: 680 times

Last updated: 07 May '15, 10:12

Related questions


© Copyright Gerger 2017