I think that would be amazing. For those of us trying to learn it, having real examples is a game changer.

Fixed it.

Had set another field to ‘Inactive’ to keep track of who was inactive and that was messing it up.  Once I removed that I could open the inactive user again.

And weird thing is I can open those changes in the java client but not in the webclient with same user role.

Any ideas?

Thanks!

Laura

We have fields called Training Required,Periodic Review Date and Document Owner (department) on page two of Documents.

We had a PX written that fills in that PRD on release of new Training document or change of existing training document with a date of todays date + 2 years.   (Prior to that the Change analyst would fill it in – that was hit or miss so we had the PX done. If it was a document released previously she wouldn’t get prompted since it was already filled in so the PX takes care of that by always updating it on any change order to the training document)

The change analyst has a saved search in her dashboard that shows any docs with a PRD in the next 2 months.

When a PRD doc comes due for review, she sends the document owner an email to review the document and she processes an MCO to record the review has taken place if minor or no changes.

If major changes to the doc are required they do an eco to roll the rev and update the document .

Thanks,
Laura

That’s what I thought.  Thank you!

Laura

Hi Steve,

Thanks for that input.

When I rename the original workflow to ‘workflow_old’ it changes the workflow name for all the changes where it was used to ‘workflow_old’ as well.   Is there any way around that?

Thanks

Laura

Hi Keith,

Thanks so much for your answer.

So we are passing the url for the document attachment folder and file to the training system. This is the query we use:

****

select item.id,

item.item_number AS Document_Number,

item.description AS Document_Description,

rev.rev_number AS Document_Rev,

rev.release_type AS Lifecycle_Phase,

rev.release_date AS Released_Date,

C.route_date AS Route_Date,

C.status change_status,

C.in_review,

P2.list20 AS Training_Required,

AM.ID AS AM_ID,

AM.Attach_ID,

A.Attachment_Number,

VSM.File_ID,

F.FileName,

F.File_Type,

F.File_Size,

CASE WHEN P2.list20 = 3496296 THEN ‘http://servernameprod:7001/Agile/link/File%20Folder/’||A.Attachment_Number||’/’||REPLACE(F.FileName,’ ‘,’%20’)

ELSE ‘http://servernamedev:7001/Agile/link/File%20Folder/’||A.Attachment_Number||’/’||REPLACE(F.FileName,’ ‘,’%20’)

END AS URL,

0 AS DOC_IS_NEW_REVISION, — Load all documents as initial for first Release

”AS DOC_SOURCE_DOCUMENT_NO,

”DOC_SOURCE_DOCUMENT_REV,

NT.Description AS DOT_TYPE

FROM item

JOIN page_two P2 on item.id=P2.id

JOIN nodetable NT on item.subclass = NT.ID

JOIN rev on item.id = rev.ITEM

JOIN change C on C.ID = rev.change

JOIN attachment_map AM on AM.parent_id = item.ID AND AM.parent_id2 = item.latest_released_eco AND AM.list01 IN (3497855,3496359)

JOIN attachment A on AM.Attach_ID = A.ID

JOIN Version_File_Map VSM on VSM.Version_ID = AM.Latest_VSN

JOIN Files F on F.ID = VSM.File_ID

WHERE P2.list20 in  (3496296,3497055)

AND rev.latest_flag = 1 AND rev.release_type IN (974,975) AND rev.rev_number <> ‘null’

AND rev.release_date >= sysdate – 10

*****

This runs in boomi. There are 2 versions – this one picks up new documents released since the last time the query was run. The other one picks up documents on changes in CCB and passes that url so training coordinator can get those set up in training system pending release of the change.

Are you saying that you pass the actual agile########.doc  in the url from the ifs vault (d:oracle\agile\agilevault) on the server?

And when you say ‘throw some type of web server on top of the file vault, such as IIS or Apache HTTP’ – is there documentation on that somewhere.?

We’re version 9.3.3 – 2 servers – one agile PLM, other DB server. The vault is sitting on the PLM server.

Thank you so much for your help!

Laura

The export completed after nearly 24 hours, it ended up at 33.1gb!!  Change history was huge 136542511 !

I will do those queries and post soon.

Here’s the export log.

I tried to import the db dmp but the import failed after BOM_RESULT.

I need to get the test db back up and make sure this company has valid backups to restore from. I think that export was the first one to complete since 2016, but what good is it if it can’t be imported?

Connected to: Oracle Database 12c Release 12.1.0.1.0 – 64bit Production
Export done in AL32UTF8 character set and AL16UTF16 NCHAR character set
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user AGILE
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user AGILE
About to export AGILE’s objects …
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export AGILE’s tables via Conventional Path …
. . exporting table ACCOUNT_LOCKOUT_NOTIFY 36 rows exported
. . exporting table ACTION_ITEM 0 rows exported
. . exporting table ACTIVITY 0 rows exported
. . exporting table ACTIVITY_BASELINE 0 rows exported
. . exporting table ACTIVITY_DEPENDENCY 0 rows exported
. . exporting table ADMINCLOBATT 0 rows exported
. . exporting table ADMINCRITERIA 829 rows exported
. . exporting table ADMINMSATT 13078 rows exported
. . exporting table ADMIN_HISTORY 8384 rows exported
. . exporting table ADMIN_HISTORY_DETAILS 8384 rows exported
. . exporting table AGGREGATED_SUBSTANCE 0 rows exported
. . exporting table AGILESEQUENCES 133 rows exported
. . exporting table AGILEUSER 323 rows exported
. . exporting table AGILE_FLEX 222023 rows exported
. . exporting table ALIAS 0 rows exported
. . exporting table APPLIEDTO 152970 rows exported
. . exporting table APPROVAL_ITEMS 0 rows exported
. . exporting table APP_PROPERTY 0 rows exported
. . exporting table ASL_MAP 0 rows exported
. . exporting table ATTACHMENT 116488 rows exported
. . exporting table ATTACHMENTS 0 rows exported
. . exporting table ATTACHMENT_MAP 66353 rows exported
. . exporting table ATTACH_REDLINE 0 rows exported
. . exporting table ATTR_PREF 0 rows exported
. . exporting table AUTHORIZED_USER 0 rows exported
. . exporting table AUTH_FAILED 2228 rows exported
. . exporting table AUTONUMBER 0 rows exported
. . exporting table AUTOSELECT_TEMP 0 rows exported
. . exporting table AVL 0 rows exported
. . exporting table A_CLUSTER_CACHE_SYNCH_LOG 6670 rows exported
. . exporting table A_CONTENT_FOLDER 20 rows exported
. . exporting table A_CONTENT_FOLDER_MAP 0 rows exported
. . exporting table A_DW_TXN_LOG 7845111 rows exported
. . exporting table A_PROJ_RSRC 0 rows exported
. . exporting table A_SUBSTANCE_ALIAS 0 rows exported
. . exporting table A_TMP_BOM_INT_PROC
. . exporting table A_UI_BLOB_DATA 0 rows exported
. . exporting table A_UI_PAGE 1 rows exported
. . exporting table A_UI_WIDGET 7 rows exported
. . exporting table A_UI_WIDGET_CONFIG 0 rows exported
. . exporting table A_UI_WIDGET_PAGE 7 rows exported
. . exporting table BASELINE_REV 0 rows exported
. . exporting table BLOB_DATA 0 rows exported
. . exporting table BOM 23992 rows exported
. . exporting table BOM_RESULT 1 rows exported
. . exporting table BO_ATTACH_VERSIONS_HISTORY 142353 rows exported
. . exporting table BUYER_LINE_CARD 0 rows exported
. . exporting table BUYER_PLANNER 0 rows exported
. . exporting table CACHE_FILE_MAP 0 rows exported
. . exporting table CACHE_FILE_MAP1 2 rows exported
. . exporting table CHANGE 9566 rows exported
. . exporting table CHANGE_HISTORY 136542511 rows exported
. . exporting table CLASS_AUTONUMBER 0 rows exported
. . exporting table CLOB_DATA 12 rows exported
. . exporting table CLUSTER_THREAD_LOCKS 22 rows exported
. . exporting table COMMODITY_DUPS 0 rows exported
. . exporting table COMPLIANCE 0 rows exported
. . exporting table CONTENT 9 rows exported
. . exporting table CONTRACT 0 rows exported
. . exporting table CONVERSION 1 rows exported
. . exporting table CRITERIA 3458 rows exported
. . exporting table CURRENCY 0 rows exported
. . exporting table CUSTOMER 36 rows exported
. . exporting table DATE_FORMAT 1 rows exported
. . exporting table DISCUSSION 1 rows exported
. . exporting table DISCUSSION_WHERE_USED 0 rows exported
. . exporting table DLS_ATTRIBUTE_INFO 0 rows exported
. . exporting table DLS_ITEM_ATTRS 0 rows exported
. . exporting table DLS_ITEM_MFGS 0 rows exported
. . exporting table DLS_ITEM_RECORDS 0 rows exported
. . exporting table DLS_ITEM_SAMPLE_DATA 0 rows exported
. . exporting table DLS_JOB_MESSAGES 0 rows exported
. . exporting table DLS_SEMANTIC_CACHE 0 rows exported
. . exporting table DL_AML 0 rows exported
. . exporting table DL_BOM 0 rows exported
. . exporting table DL_REV 0 rows exported
. . exporting table EHUB_HEARTBEAT 1 rows exported
. . exporting table EHUB_STATE 1 rows exported
. . exporting table ESCALATIONS 2 rows exported
. . exporting table EVENT_HISTORY 8844 rows exported
. . exporting table EXTENSION_MODULES 0 rows exported
. . exporting table EXTENSION_PROCEDURES 0 rows exported
. . exporting table EXTERNAL_OBJECT 0 rows exported
. . exporting table FACT_TABLE 0 rows exported
. . exporting table FACT_TABLE_TASK 0 rows exported
. . exporting table FILES 129057 rows exported
. . exporting table FILE_INFO 132832 rows exported
. . exporting table FILE_UPLOAD_FILEINFO 9 rows exported
. . exporting table FLEX_FIELD 0 rows exported
. . exporting table FOLDER 2782 rows exported
. . exporting table FOLDERING 19264 rows exported
. . exporting table FOLDER_STRUCTURE 0 rows exported
. . exporting table GAP_TABLE 0 rows exported
. . exporting table GEOGRAPHY_ROUTING 0 rows exported
. . exporting table GROUP_HEADER 0 rows exported
. . exporting table GROUP_LINE 0 rows exported
. . exporting table HISTORY 0 rows exported
. . exporting table HISTORY_FILE_UPLOAD 13818 rows exported
. . exporting table INBOX 0 rows exported
. . exporting table INBOX_USER 0 rows exported
. . exporting table INSTANCES 0 rows exported
. . exporting table ITEM 13558 rows exported
. . exporting table ITEM_HISTORY 648040 rows exported
. . exporting table ITEM_HISTORY2 169 rows exported
. . exporting table ITEM_SITES 0 rows exported
. . exporting table LANGTABLE 0 rows exported
. . exporting table LICENSE_EVENTS 0 rows exported
. . exporting table LISTENTRY 7836 rows exported
. . exporting table LISTNAME 674 rows exported
. . exporting table LIST_TABLE 0 rows exported
. . exporting table MANUFACTURER 0 rows exported
. . exporting table MANUFACTURERS 552 rows exported
. . exporting table MANU_BY 22714 rows exported
. . exporting table MANU_PARTS 7391 rows exported
. . exporting table MATERIAL_DECLARATION 0 rows exported
. . exporting table MATERIAL_DECLARATION_MAP 0 rows exported
. . exporting table METAFILES_QUEUE 0 rows exported
. . exporting table MODATT 64 rows exported
. . exporting table MSATT 167689 rows exported
. . exporting table MSP_ACTIVITY_FILE_MAP 0 rows exported
. . exporting table MSP_RESOURCE_MAP 0 rows exported
. . exporting table NEWS 0 rows exported
. . exporting table NODETABLE 28209 rows exported
. . exporting table NOTIFICATION 3069 rows exported
. . exporting table NOTIFICATION_FIELDS 26815 rows exported
. . exporting table NOTIFICATION_TEMPLATE 17 rows exported
. . exporting table NOTIFICATION_USER 3095 rows exported
. . exporting table NOTIFY_ATTRIBUTE 6735 rows exported
. . exporting table NOTIFY_FROM 1 rows exported
. . exporting table NOTIFY_HISTORY 0 rows exported
. . exporting table NOTIFY_HISTORY_ATT 0 rows exported
. . exporting table NOTIFY_TEMPLATE 474 rows exported
. . exporting table OBJECTACL 3970 rows exported
. . exporting table OBJECT_DETAIL 205 rows exported
. . exporting table OBJECT_LOCKS 0 rows exported
. . exporting table OBJECT_MAP 4903 rows exported
. . exporting table ONETIME_PX_TOKENS 0 rows exported
. . exporting table ORGANIZATION 1 rows exported
. . exporting table OUTBOUND 11287 rows exported
. . exporting table OUTBOUND_LOCK 1547 rows exported
. . exporting table OUTBOUND_OBJECTS 11287 rows exported
. . exporting table OUTBOUND_TRACK 0 rows exported
. . exporting table OUTBOUND_WHERESENT 20477 rows exported
. . exporting table OUTPUT_BOM 6676 rows exported
. . exporting table PAGE_THREE 169399 rows exported
. . exporting table PAGE_TWO 169717 rows exported
. . exporting table PART_FAMILY 2 rows exported
. . exporting table PART_FAMILY_MAP 0 rows exported
. . exporting table PDP 1 rows exported
. . exporting table PDQ_ITEM_DICTIONARY 0 rows exported
. . exporting table PERS_CRITERIA 0 rows exported
. . exporting table PERS_CRITERIA_NODE 0 rows exported
. . exporting table PGC_FIND_TLA 0 rows exported
. . exporting table PGC_ROLLUP_PART 0 rows exported
. . exporting table PGC_SMART_ROLLUP_TRIGGER 0 rows exported
. . exporting table PGC_SMART_ROLLUP_TRIGGER_CP 0 rows exported
. . exporting table PRICE 0 rows exported
. . exporting table PRICEENTRY 0 rows exported
. . exporting table PRICELINE 0 rows exported
. . exporting table PRICEPOINT 0 rows exported
. . exporting table PRICE_HISTORY 0 rows exported
. . exporting table PRODUCT_LINE 0 rows exported
. . exporting table PRODUCT_LINE_MAP 0 rows exported
. . exporting table PROGRAM 0 rows exported
. . exporting table PROGRAM_HISTORY 1 rows exported
. . exporting table PROGRAM_LOCKS 0 rows exported
. . exporting table PROGRAM_TEMPLATE 1 rows exported
. . exporting table PROJECT 0 rows exported
. . exporting table PROPERTYTABLE 274097 rows exported
. . exporting table PSR 9822 rows exported
. . exporting table PSR_ITEM 9424 rows exported
. . exporting table PS_REPORT_HEADER 0 rows exported
. . exporting table QCR 105 rows exported
. . exporting table QCR_AI 10 rows exported
. . exporting table QUERY 2043 rows exported
. . exporting table QUERY_REORG_LOG 0 rows exported
. . exporting table QUERY_TABLE 262 rows exported
. . exporting table QUOTE_HISTORY 0 rows exported
. . exporting table RECURRENCE 12 rows exported
. . exporting table REDLINE_ATTRIBUTE 14265 rows exported
. . exporting table REDLINE_MSATTRIBUTE 8552 rows exported
. . exporting table REFDESIG 33953 rows exported
. . exporting table REFERENCE_OBJECT 0 rows exported
. . exporting table REGION 12 rows exported
. . exporting table REGION_CONTENT 12 rows exported
. . exporting table REGULATION 0 rows exported
. . exporting table REGULATION_ADDORREPLACE_ACTION 0 rows exported
. . exporting table REGULATION_ADDORREPLACE_TASK 0 rows exported
. . exporting table REGULATION_PAGE2_MAPPING 0 rows exported
. . exporting table RELATIONSHIP 18209 rows exported
. . exporting table REMOTE_USER 0 rows exported
. . exporting table RENDITION_FILE_MAP 8 rows exported
. . exporting table REPORT 457 rows exported
. . exporting table REPORT_LAYOUT 375 rows exported
. . exporting table REPORT_TEMPLATE 0 rows exported
. . exporting table RESPONSE 0 rows exported
. . exporting table RESPONSE_HEADER 0 rows exported
. . exporting table RESPONSE_RFQ_MAPPING 0 rows exported
. . exporting table RESPONSE_RFQ_TERMS 0 rows exported
. . exporting table RESULT_OBJECT_COMPLIANCE 0 rows exported
. . exporting table RESULT_SUBSTANCE_COMPLIANCE 0 rows exported
. . exporting table REV 43158 rows exported
. . exporting table RFQ_COMMENT 0 rows exported
. . exporting table RFQ_COMMENT_RECIPIENT 0 rows exported
. . exporting table RFQ_HEADER 0 rows exported
. . exporting table RFQ_LINE 0 rows exported
. . exporting table ROLLUP_COMPOSITION 0 rows exported
. . exporting table ROLLUP_COMPOSITION_DECL
. . exporting table ROOT_OBJECT 0 rows exported
. . exporting table ROW_TABLE 24 rows exported
. . exporting table SCHEDULED_EVENT 24 rows exported
. . exporting table SCHEDULED_EVENT_TRACKING 43 rows exported
. . exporting table SCRIPT_MAINT 17 rows exported
. . exporting table SC_AML 0 rows exported
. . exporting table SC_BOM 0 rows exported
. . exporting table SC_COMMENT 0 rows exported
. . exporting table SC_COST_QTY_ROLLUP 0 rows exported
. . exporting table SC_DELTA_BOM 0 rows exported
. . exporting table SC_ITEM 0 rows exported
. . exporting table SC_PROJECT_SITES 0 rows exported
. . exporting table SC_SUPPLIERS 0 rows exported
. . exporting table SC_WORK_IN_PROGRESS 0 rows exported
. . exporting table SEARCH 0 rows exported
. . exporting table SECTION 5 rows exported
. . exporting table SELECT_LIST 12100 rows exported
. . exporting table SERVERHOST 1 rows exported
. . exporting table SERVER_LICENSE 292 rows exported
. . exporting table SIGNOFF 258012 rows exported
. . exporting table SIMPLE_QUERY_HISTORY 0 rows exported
. . exporting table SIMPLE_RELATION 3920 rows exported
. . exporting table SITE 0 rows exported
. . exporting table SITES 1 rows exported
. . exporting table SPECIFICATION_SUBSTANCES 0 rows exported
. . exporting table STATEACTIVITY_RELATIONS 0 rows exported
. . exporting table STYLE 5 rows exported
. . exporting table SUBSCRIBER_TRACK 0 rows exported
. . exporting table SUBSCRIPTIONS 396 rows exported
. . exporting table SUBSCRIPTIONS_BADREC_BACKUP 0 rows exported
. . exporting table SUBSTANCE 2 rows exported
. . exporting table SUBSTANCE_MAP 0 rows exported
. . exporting table SUPPLIER_LINE_CARD 0 rows exported
. . exporting table SUPPLIER_MDO_PX 15 rows exported
. . exporting table SYSTEM_MEMORY 0 rows exported
. . exporting table TABLEINFO 54648 rows exported
. . exporting table TABLE_FILTER 278 rows exported
. . exporting table TABLE_VIEW 652 rows exported
. . exporting table TAB_DISP_CONFIG 0 rows exported
. . exporting table TAB_DISP_CONFIG_INFO 0 rows exported
. . exporting table TA_ESC 0 rows exported
. . exporting table TEAM 0 rows exported
. . exporting table TEAM_BASELINE 0 rows exported
. . exporting table TEMPLATE 3 rows exported
. . exporting table THUMBNAIL_FILE_MAP 0 rows exported
. . exporting table THUMBNAIL_OBJECT_MAP 0 rows exported
. . exporting table TIMESHEET 0 rows exported
. . exporting table TMPUSER 1 rows exported
. . exporting table TMP_ROLLUP
. . exporting table TRANSFERAUTH 141 rows exported
. . exporting table TRANSFERFLAG 0 rows exported
. . exporting table T_ACT_APP 0 rows exported
. . exporting table T_ACT_CLA 0 rows exported
. . exporting table T_ACT_DAT 0 rows exported
. . exporting table T_ACT_HIS 0 rows exported
. . exporting table T_ACT_SNG 0 rows exported
. . exporting table T_ACT_STR 0 rows exported
. . exporting table T_BAS_USER 0 rows exported
. . exporting table T_CLA_DAT 0 rows exported
. . exporting table T_DEFAULT 4 rows exported
. . exporting table T_DEF_PERIODS 6 rows exported
. . exporting table T_DSB_DAT 0 rows exported
. . exporting table T_DSB_ELM 0 rows exported
. . exporting table T_DSB_STR 0 rows exported
. . exporting table T_EWO_DAT 0 rows exported
. . exporting table T_EWR_DAT 0 rows exported
. . exporting table T_FIELD 6 rows exported
. . exporting table T_GROUP 0 rows exported
. . exporting table T_GROUP_DAT 0 rows exported
. . exporting table T_GRP_ART 0 rows exported
. . exporting table T_GRP_CLA 0 rows exported
. . exporting table T_GRP_PRC 0 rows exported
. . exporting table T_GRP_USR 0 rows exported
. . exporting table T_MAIL_DAT 0 rows exported
. . exporting table T_MASK 1 rows exported
. . exporting table T_MAS_FLD 8 rows exported
. . exporting table T_MENU 2 rows exported
. . exporting table T_MEN_SEL 9 rows exported
. . exporting table T_NUM_BLK 9 rows exported
. . exporting table T_NUM_GEN 8 rows exported
. . exporting table T_ORG_DAT 0 rows exported
. . exporting table T_POS_DAT 0 rows exported
. . exporting table T_PRC_DAT 0 rows exported
. . exporting table T_PRC_HIS 0 rows exported
. . exporting table T_PRO_DAT 0 rows exported
. . exporting table T_PRS_DAT 0 rows exported
. . exporting table T_ROL_DAT 0 rows exported
. . exporting table T_ROL_STR 0 rows exported
. . exporting table T_ROL_TSK 0 rows exported
. . exporting table T_SELECTION 9 rows exported
. . exporting table T_TSK_DAT 0 rows exported
. . exporting table T_USER 0 rows exported
. . exporting table T_WFL_CON 47 rows exported
. . exporting table UPG88 0 rows exported
. . exporting table USAGE_HISTORY 0 rows exported
. . exporting table USER_APPROVAL_PASSWORD_HISTORY 36 rows exported
. . exporting table USER_ASSIGNMENT 2786 rows exported
. . exporting table USER_BOOKMARK 0 rows exported
. . exporting table USER_DEFAULT_TABLEVIEW 16 rows exported
. . exporting table USER_FUNCTION_MAP 16 rows exported
. . exporting table USER_GROUP 12 rows exported
. . exporting table USER_LICENSE 288 rows exported
. . exporting table USER_PASSWORD_HISTORY 312 rows exported
. . exporting table USER_POLICY 156 rows exported
. . exporting table USER_ROLE 0 rows exported
. . exporting table USER_SESSION 13 rows exported
. . exporting table USER_SITE 0 rows exported
. . exporting table USER_USAGE_HISTORY 2378593 rows exported
. . exporting table VAULT 2 rows exported
. . exporting table VERSION 129067 rows exported
. . exporting table VERSION_FILE_MAP 130072 rows exported
. . exporting table VISIT_HISTORY 0 rows exported
. . exporting table WORKFLOW_PROCESS 170245 rows exported
. . exporting table WORKFLOW_RULES 0 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.

Thanks,

Laura

Hi Keith,

I started an export last night at 7:00pm and it’s still running 12 hours later! It’s now 17.1gb and log still shows it is on change_history! I’ve never seen a db dmp so big.

I just used the agile9exp.bat job:

set NLS_LANG=American_America.AL32UTF8
set ORACLE_HOME=D:\oracle\product\12.1.0\dbhome_1
set ORACLE_SID=agile9

%ORACLE_HOME%\bin\sqlplus agile/%PW_AGILE% @removestatsjob.sql
%ORACLE_HOME%\bin\exp agile/%PW_AGILE% parfile=agile9exp.par
%ORACLE_HOME%\bin\sqlplus agile/%PW_AGILE% @submitstatsjob.sql

parfile: file=agile9exp120519.dmp log=agile9exp120519.log owner=agile

Do you think I should stop it? I’ve never seen a dmp file so big. The company has been on agile since 2013.

I found one dmp file from 2016 on the server that was 4.89gb back then so I figured it would be around 9gb now but this is much larger.

I know they did use PC and PQM.

Here’s what the ora files look like:

https://link.shutterfly.com/PH2sJypzc2

Let me know if you think the dmp file is ok.

Thanks,

Laura

And the server has 8gb RAM and plenty of disc space.

Hi,

Sorry, here is the log file.  It just ends, doesn’t give any errors.

******
Connected to: Oracle Database 12c Release 12.1.0.1.0 – 64bit Production
Export done in UTF8 character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)

About to export specified users …
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user AGILE
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user AGILE
About to export AGILE’s objects …
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export AGILE’s tables via Conventional Path …
. . exporting table ACCOUNT_LOCKOUT_NOTIFY 36 rows exported
. . exporting table ACTION_ITEM 0 rows exported
. . exporting table ACTIVITY 0 rows exported
. . exporting table ACTIVITY_BASELINE 0 rows exported
. . exporting table ACTIVITY_DEPENDENCY 0 rows exported
. . exporting table ADMINCLOBATT 0 rows exported
. . exporting table ADMINCRITERIA 829 rows exported
. . exporting table ADMINMSATT 13078 rows exported
. . exporting table ADMIN_HISTORY 8384 rows exported
. . exporting table ADMIN_HISTORY_DETAILS 8384 rows exported
. . exporting table AGGREGATED_SUBSTANCE 0 rows exported
. . exporting table AGILESEQUENCES 133 rows exported
. . exporting table AGILEUSER 322 rows exported
. . exporting table AGILE_FLEX 221963 rows exported
. . exporting table ALIAS 0 rows exported
. . exporting table APPLIEDTO 152970 rows exported
. . exporting table APPROVAL_ITEMS 0 rows exported
. . exporting table APP_PROPERTY 0 rows exported
. . exporting table ASL_MAP 0 rows exported
. . exporting table ATTACHMENT 116446 rows exported
. . exporting table ATTACHMENTS 0 rows exported
. . exporting table ATTACHMENT_MAP 66333 rows exported
. . exporting table ATTACH_REDLINE 0 rows exported
. . exporting table ATTR_PREF 0 rows exported
. . exporting table AUTHORIZED_USER 0 rows exported
. . exporting table AUTH_FAILED 2226 rows exported
. . exporting table AUTONUMBER 0 rows exported
. . exporting table AUTOSELECT_TEMP 0 rows exported
. . exporting table AVL 0 rows exported
. . exporting table A_CLUSTER_CACHE_SYNCH_LOG 6670 rows exported
. . exporting table A_CONTENT_FOLDER 20 rows exported
. . exporting table A_CONTENT_FOLDER_MAP 0 rows exported
. . exporting table A_DW_TXN_LOG 7839448 rows exported
. . exporting table A_PROJ_RSRC 0 rows exported
. . exporting table A_SUBSTANCE_ALIAS 0 rows exported
. . exporting table A_TMP_BOM_INT_PROC
. . exporting table A_UI_BLOB_DATA 0 rows exported
. . exporting table A_UI_PAGE 1 rows exported
. . exporting table A_UI_WIDGET 7 rows exported
. . exporting table A_UI_WIDGET_CONFIG 0 rows exported
. . exporting table A_UI_WIDGET_PAGE 7 rows exported
. . exporting table BASELINE_REV 0 rows exported

*********

The  dmp file that got created from that daily backup last night that didn’t finish ended up being 1,465,120kb.

I’m trying another export now after kicking all users off system to see if that works.

So far its up to CHANGE_HISTORY… that table is always big, hopefully it’ll get through.

If it doesn’t, are there any other places to look for errors.

No one has been doing db maintenance so maybe I need to run averify.

IT confirmed there aren’t any disc errors or system issues on this virtual machine.

Thanks,

Laura