API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 29th, 2017
117
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.51 KB | None | 0 0
raw download clone embed print report
  1. Wed Aug 03 12:01:01 CEST 2016 -> Indicator list (after frequency check): 10_PK_INSIGHTS_MASTER_DATA_SHM.RUN;20_PK_INSIGHTS_INDICATORS_SHM.RUN_SHM_LOTS;30_PK_INSIGHTS_INDICATORS_SHM.RUN_SHM_LOTS_1
  2. Wed Aug 03 12:01:01 CEST 2016 -> [CONNECTING][jdbc:oracle:thin:@10.92.11.40:1521:DSPLJ][][]
  3. Wed Aug 03 12:01:01 CEST 2016 -> [CONNECTED][jdbc:oracle:thin:@10.92.11.40:1521:DSPLJ][][]
  4. Wed Aug 03 12:01:01 CEST 2016 -> Check that _date_to is in the past
  5. Wed Aug 03 12:01:01 CEST 2016 -> SQL : select sysdate - to_date('01/01/20','DD/MM/RR HH24:MI') from dual
  6. Wed Aug 03 12:01:01 CEST 2016 -> Param modification _date_to : 03/08/16 12:01
  7. Wed Aug 03 12:01:01 CEST 2016 -> Starting calculation for indicator : 10_PK_INSIGHTS_MASTER_DATA_SHM.RUN
  8. Wed Aug 03 12:01:01 CEST 2016 -> [CONNECTING][jdbc:oracle:thin:@10.92.11.40:1521:DSPLJ][][]
  9. Wed Aug 03 12:01:01 CEST 2016 -> From 03/08/16 11:46 to 03/08/16 12:01
  10. Wed Aug 03 12:01:01 CEST 2016 -> [PACKAGE_RUN][PK_INSIGHTS_MASTER_DATA_SHM.RUN][BEGIN][BEGIN PK_INSIGHTS_MASTER_DATA_SHM.RUN('_remove_orphans=y;_npo=3;_stormbase_user=admin;_full_backup_frequency=7;_keep.ALL=10;_csv_delete=n;_port=1521;_server=10.92.11.40;_keep.DAILY_MVT=730;_rebates_impact_cp=n;_wlast_download_ignore_window=n;_password=giihuston;_margin_filter_factor=10;_stormbase_rownum=n;_debug=n;_special_ops=n;_filter_inconsistent_rows=y;_lang=SL;_spe_period=n;_sid=DSPLJ;_stormbase_password=admin;_gold_version=510;_nmonth=3;_resid=1;_inventory_type=ALL;_sql_dir=SHM;_calculate_indicators=y;_unload_filter_time=0;_dblink_count=GSP1KR.VPOGLED,GSP1LJ.VPOGLED,GSP1LZ.VPOGLED,GSP1MM.VPOGLED,GSP1PT.VPOGLED;_dblink=GSP1KR.VPOGLED;_sp_artcaisse=y;_spe_period_code=ALL;_ms=1;_stormbase_insert=y;_keep.LIVE_MVT=15;_stormbase_server=localhost;_stormbase_port=2559;_dummy_test=n;_ndays_forecast=120;_indicators_frequency.ALL=* * *;_auth_assortment=sellable;_filter_daily_mvt_future=y;_csv_bck=y;_price_list=n;_user=GII_HUSTON;_special_ops_code=ALL;_site_list=ALL;_indicators_list=10_PK_INSIGHTS_MASTER_DATA_SHM.RUN;20_PK_INSIGHTS_INDICATORS_SHM.RUN_SHM_LOTS;30_PK_INSIGHTS_INDICATORS_SHM.RUN_SHM_LOTS_1;_price_list_code=ALL;_csv=y;_keep.WEEKLY_MVT=3650;_stormbase_refresh=y;_authorize_negative_stock=n;_date_from=03/08/16 11:46;_sales_price_line=0;_date_to=03/08/16 12:01;_stormbase_internal_bck=y;');END;]
  11. Wed Aug 03 12:01:01 CEST 2016 -> [CONNECTED][jdbc:oracle:thin:@10.92.11.40:1521:DSPLJ][][]
  12. Wed Aug 03 12:01:06 CEST 2016 -> [PACKAGE_RUN][PK_INSIGHTS_MASTER_DATA_SHM.RUN][END][OK]
  13. Wed Aug 03 12:01:06 CEST 2016 -> Starting calculation for indicator : 20_PK_INSIGHTS_INDICATORS_SHM.RUN_SHM_LOTS
  14.  
  15. Wed Mar 29 10:01:02 CEST 2017 -> Indicator list (after frequency check): 10_PK_INSIGHTS_MASTER_DATA_SHM.RUN;20_PK_INSIGHTS_INDICATORS_SHM.RUN_SHM_LOTS;30_PK_INSIGHTS_INDICATORS_SHM.RUN_SHM_LOTS_1;40_PK_INSIGHTS_INDICATORS_SHM.RUN_SHM_LOTS_2;50_PK_INSIGHTS_INDICATORS_SHM.RUN_SHM_LOTS_3
  16. Wed Mar 29 10:01:02 CEST 2017 -> [CONNECTING][jdbc:oracle:thin:@10.92.11.40:1521:DSPLJ][][]
  17. Wed Mar 29 10:01:02 CEST 2017 -> java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
  18. Wed Mar 29 10:01:02 CEST 2017 -> Io exception: The Network Adapter could not establish the connection
  19. Wed Mar 29 10:01:02 CEST 2017 -> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
  20. Wed Mar 29 10:01:02 CEST 2017 -> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
  21. Wed Mar 29 10:01:02 CEST 2017 -> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
  22. Wed Mar 29 10:01:02 CEST 2017 -> oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
  23. Wed Mar 29 10:01:02 CEST 2017 -> oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:439)
  24. Wed Mar 29 10:01:02 CEST 2017 -> oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
  25. Wed Mar 29 10:01:02 CEST 2017 -> oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
  26. Wed Mar 29 10:01:02 CEST 2017 -> oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
  27. Wed Mar 29 10:01:02 CEST 2017 -> java.sql.DriverManager.getConnection(DriverManager.java:664)
  28. Wed Mar 29 10:01:02 CEST 2017 -> java.sql.DriverManager.getConnection(DriverManager.java:247)
  29.  
  30.  
  31.  
  32. GII_H> cat /orasw/app/oracle/product/11204/network/admin/tnsnames.ora
  33. dsplj=
  34. (DESCRIPTION =
  35. (ADDRESS = (PROTOCOL = TCP)(HOST = me31-scan.mercator.si)(PORT=1521))
  36. (CONNECT_DATA = (SERVICE_NAME = dsplj.mercator.si)(server=dedicated) )
  37.  
  38.  
  39. GII_H> grep -ir "10.92.11.40" . | egrep -v log
  40. ./DB/GOLD_INSIGHTS_SHM_test.conf.bck.nv:_server=10.92.11.40
  41. ./DB/GOLD_INSIGHTS_SHM_test.conf:_server=10.92.11.40
  42.  
  43.  
  44.  
  45.  
  46. GII_H> grep -ir "The Network Adapter could not establish the connection" . | head -n 30
  47. ./GOLD_INSIGHTS_SHM_test_new.2017.03.14:16:31:01.log:Tue Mar 14 16:31:02 CET 2017 -> java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
  48. ./GOLD_INSIGHTS_SHM_test_new.2017.03.14:16:31:01.log:Tue Mar 14 16:31:02 CET 2017 -> Io exception: The Network Adapter could not establish the connection
  49. ./GOLD_INSIGHTS_SHM_test_new.2017.03.14:16:31:01.log:java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
  50. ./GOLD_INSIGHTS_SHM_test_new.2017.03.14:16:46:01.log:Tue Mar 14 16:46:02 CET 2017 -> java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
  51. ./GOLD_INSIGHTS_SHM_test_new.2017.03.14:16:46:01.log:Tue Mar 14 16:46:02 CET 2017 -> Io exception: The Network Adapter could not establish the connection
  52.  
  53.  
  54.  
  55.  
  56. Tue Mar 14 16:16:01 CET 2017 -> Indicator list (after frequency check): 10_PK_INSIGHTS_MASTER_DATA_SHM.RUN;20_PK_INSIGHTS_INDICATORS_SHM.RUN_SHM_LOTS;30_PK_INSIGHTS_INDICATORS_SHM.RUN_SHM_LOTS_1;40_PK_INSIGHTS_INDICATORS_SHM.RUN_SHM_LOTS_2;50_PK_INSIGHTS_INDICATORS_SHM.RUN_SHM_LOTS_3
  57. Tue Mar 14 16:16:01 CET 2017 -> [CONNECTING][jdbc:oracle:thin:@10.92.11.40:1521:DSPLJ][][]
  58. Tue Mar 14 16:16:02 CET 2017 -> [CONNECTED][jdbc:oracle:thin:@10.92.11.40:1521:DSPLJ][][]
  59.  
  60.  
  61. Tue Mar 14 16:31:02 CET 2017 -> Indicator list (after frequency check): 10_PK_INSIGHTS_MASTER_DATA_SHM.RUN;20_PK_INSIGHTS_INDICATORS_SHM.RUN_SHM_LOTS;30_PK_INSIGHTS_INDICATORS_SHM.RUN_SHM_LOTS_1;40_PK_INSIGHTS_INDICATORS_SHM.RUN_SHM_LOTS_2;50_PK_INSIGHTS_INDICATORS_SHM.RUN_SHM_LOTS_3
  62. Tue Mar 14 16:31:02 CET 2017 -> [CONNECTING][jdbc:oracle:thin:@10.92.11.40:1521:DSPLJ][][]
  63. Tue Mar 14 16:31:02 CET 2017 -> java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
  64. Tue Mar 14 16:31:02 CET 2017 -> Io exception: The Network Adapter could not establish the connection
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!