on 09-30-2013 8:58 AM
Hi,
With reference to the below post. We want Since SI_SCHEDULE_STATUS column in one of our report.Since CMS database is encrypted, is there a way to decrypt it or is there any other possible to achieve this.
http://scn.sap.com/thread/3429570
Please help.
Thanks,
Mahesh.M
Hi
Please post the exact error message.
Sandeep
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sorry for not being clear in my post. The thing is, From my previous post (http://scn.sap.com/thread/3429570) I got the information that we can get Job failure Error Message from SI_SCHEDULE_STATUS Column from Query Builder. I want this information in Database. So that it can be used in reports. Following are my queries,
1. Which column in CMS DB holds the Job Failure Error Message?
2. CMS DB is Encrypted is there anyway to decrypt or get the error message in understandable format?
Thanks,
Mahesh.M
Mahesh M.
you can write a Java program based on the BOE SDK that dumps the status incl. the Name, CUID (or what ever other attribute you need) in a text file (CSV format). You can use the file as data source for your reports.
Unless you have somewhere a database accessible over JDBC and you can directly dump the BO repo data from the java program in a DB table instead.
Regards,
Stratos
ObjName would be the column of your interest. Have tried to decrypt the CMS table contents without any major success.
Refer the same data from CMS_InfoObjects7 table.
ObjectID | ParentID | TypeID | OwnerID | Version | LastModifyTime | ScheduleStatus | NextRunTime | CRC | Properties | SI_GUID | SI_CUID | SI_RUID | SI_INSTANCE_OBJECT | SI_PLUGIN_OBJECT | SI_TABLE | SI_HIDDEN_OBJECT | SI_RECURRING | SI_RUNNABLE_OBJECT | SI_PSS_SERVICE_ID | SI_CRYPTOGRAPHIC_KEY | SI_NAMEDUSER | SI_KEYWORD | SI_KEYWORD_TR | MOBILE_READY | MOBILE_READY_TR | LOV_KEY | SI_TENANT_ID | ObjName | ObjName_TR |
100 | 65 | 65 | 12 | 1 | 0x3230313320303920313620313220323220313520333036 | 0x31393936343937333134 | 0x04000000001a04010010000000000064000000010000014126b89e0a82d77475fb97dfc9a14e372a4efeee08df164d97f5da78459ca0913d18245fff7ecaf9db6c4effa6684c5ccab4c0b8d260f19d6257aa2f2160e94feac1003d1985409eea2c4393aed4beb4f6360cbdf1a131943eeb5f6b578894280dd3a37509b1deb9f94405818541b029c4984f8c76fe99d155790368f859bd5d529bf1613ec2ba8bd1b8263e7c24f3579023cb2532c28e24f4cbfac43b409f4cccca88b3c4d015ac71e04bdeed6079a5ac84090b95b78d7ded669912d78595c2f400b6b722b79b5cb6e0b18182d7755883c9a3ab621ec825e5043f6407b7da574cf83c6c2b5f39e9ef | 0x4156496742476d37306c56426a443047304f7075303777 | 0x4156496742476d37306c56426a443047304f7075303777 | 0x4156496742476d37306c56426a443047304f7075303777 | 0 | 0 | 2 | 0 | 0 | 0 | 4 | 0 | 0 | 0x2d4b59474f45354b294737392d21407b3d31592140607c3e21607c3c21607c3c213b53 | 0 | ||||||||
107 | 44 | 44 | 12 | 1 | 0x3230313320303920313620313220323220313620313634 | 0x393030323036303238 | 0x0000017d785e7d504d4f834010f5c7903d6d9afd84bd4c1422556c2d84b6b1f5c2c515b696c6da1a50e37f778778301cbccc4c66debc376f2411c059449924129659354bb70f79794d5941346586842070168152980d70ec5e425c26ab6ee3d2c5ae5cbc1a176d227b7b6a33dc4b10e1190c49314c31dc406cdf3fba723aef8a2439b7d5def58dd5ea0517b2ffd8ee7e95674833073e9c730f8a6b29279a6b152a13724e5544c40a3157cb3f3e2af7d44ffa768f32f9f3c8605ec3e9fce60ef5306d90387720b437eeabdd085dc4600f88acb7f025c9da83bea960eb4f523f8e1a8dff29721c87671dadaf8320189f1c5cfc005fc7634f | 0x416575797752464c77504242746d5f6c6978686535346b | 0x41524254775869454e6a524e7038693758376548736d49 | 0x41524254775869454e6a524e7038693758376548736d49 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0x4d3921417c4e223d315955454b2f213b48 | 0 | ||||||||
102 | 66 | 66 | 10 | 1 | 0x3230313320303920313620313220323220313620313830 | 0x33363132393735303335 | 0x00000684785ead545b6fab3810de1f53f5a93ab221a4e1215ac50918d38480c1e6f2521d434b08769aa326e4f2ebd7a4ad36ed6a8f56d53e7840e3f1cc37976fcc5b630c817107cc5b731c93c707274f9774f6d854c71f4725ef40786bdd81d1ed707cb1b91f0f87fd773486bdf6cff1a46c1c077a8f846de72fc22d59a8707524fd3bd45bcc7ae1f4c2ed05fedd03f2bb4bff3df243ef66ae31f73016e301b44cf38705adc1d00283a17937b8bf85b8b731925eae747abde5068d27142587ac7182350db6a3e63ebb7ff25ed505ea96bce5f3eb4d3ef52f3a7b1cceec81480f75a5f8a9346427d6a059c483036990142ae80a2cf7c519345546d53ca91b321b | 0x416369454531485f4955704c6f62466355506d47647849 | 0x416369454531485f4955704c6f62466355506d47647849 | 0x416369454531485f4955704c6f62466355506d47647849 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0x4d3921417c4e223d315955454b2f21417c4e22392f572142457b57413f213b50 | 0 | ||||||||
110 | 44 | 44 | 12 | 1 | 0x3230313320303920313620313220323220313620393434 | 0x33323037373535313939 | 0x0000018d785e7d50cb4ec33010e463229facc88eedc61c5690920021491d35f4502e11d0e09a86d2f250aa22fe9d6cc429425cc6d66a7666670409807346992002aab42ecc34cd937a9e44f192b29228ca349940808410a4c45703c7e9194495297617f76df9aae29d76cde7aa3d762ec5bd2932628404e112e10aa2874d96a761d6e5f37cf338f12dbb166cd6e142fa9fdacdaf73863239f0e19c02245742f88a2b190aadf5299521096e91735e8dc3d46e75f00f2f2d7a99a7bfa21a0bef1f6f6e6b07ca1a2d8c03314436cf306ea68ca0d922d52ee14b90454ffba6015b1c89bd1b0dd67dc7a8b21f7adb37fddff3bcf1f5dec90fd33967af | 0x41626b4b4c49374b774c524c6b63362e67304833304e77 | 0x41534f4d7043616c506f35447038696575646c7a776949 | 0x41534f4d7043616c506f35447038696575646c7a776949 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0x4d3921417c4e2241452b393f3121417c4e224b31292f59213b4d | 0 | ||||||||
105 | 66 | 66 | 10 | 1 | 0x3230313320303920313620313220323220313620393630 | 0x31303734363739323135 | 0x00000502785e9d54db6ea33010dd8fa9f254553697061ed02a2401ec06c2c5368497a8404208264dd54d48f2f56ba7bbda5eb417ed83c7923d33e7cc99b1d5816241a0df0275a05a095afa731bcda6cb783a9a2c964d75ba3b75fc168403e1610cee2d453a0eadfb7bb91b1694a75fadd1ea412b977cb8beb3f1cb61b378e6939db27b9271b6f498483395c691c6fd5300fad325fe81fc20d3cc047149c3b734a8abea9d0e756da881a1066fb5e100bad24721d26e448dd273675ba364eeefc78f3c7cd2277ba3591d2a7ee91b24a9eed16b3dcfaf7625238ea6154e4cad48fbbaead8b954f8b1d882c64fb41e35362fbae098bbfc905f405365713723758326 | 0x41654b34635f6c37662e424a73756859716c446e326e6f | 0x41654b34635f6c37662e424a73756859716c446e326e6f | 0x41654b34635f6c37662e424a73756859716c446e326e6f | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0x4d3921417c4e2241452b393f3121417c4e224b31292f5921417c4e22392f572142457b57413f213b55 | 0 | ||||||||
108 | 44 | 44 | 12 | 1 | 0x3230313320303920313620313220323220313720353533 | 0x343736353032313938 | 0x00000175785e7d50c14ec3300ce563aa9caa2a69129a1dacad680195166552b76adda54263b4412dd00d4105e2df57471ca61eb83c5bf6f3b3fd38098151e5534e38e4499599a24a75e9d315913e55e41a42ec45200446050cab7388f35cefd3d9a1d8b671d730dd2fbfb26218392b72838c258246b845b88378fb796c83b5def545d2e6a5e29d29dededd40f29fdafddfe614653260ee9c07104c721e482685a2331e495f44245c2367915ffc51d9a72118ba16d798e7c983a686c7d3dedad3c7d1bed68ed2a0bab1c09c23e6052efca84bf8e16433367efd906ebe49bd9b149ad14b9ceb9d49fd61cc3dcf9b9eea5d9d01ef12614c | 0x415876726c2e54455a7156496c535938336d4f566f7034 | 0x41535345634b396556586c416d6831457144774c567834 | 0x41535345634b396556586c416d6831457144774c567834 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0x4d3921417c4e223f455321417c4e223d3159213b48 | 0 | ||||||||
103 | 66 | 66 | 10 | 1 | 0x3230313320303920313620313220323220313720353638 | 0x32393435343533333037 | 0x00000685785e9d54db6ea34810dd8f89f2148d1a30093c582b632e6e626373691afa25324d0298c6211b9b8bbf7ebaed6427c9ac664783442135d55575ea9c2ae55a9e4a40b901cab5320de1c3721d3fdc5be943950fdf8686dd80cdb57a03b4ebdba92c7ceea6b7b7e2ab4d2571faf77446d8ea74e7ac3bd0ce5a3cf65abb0f555913f70ce1610a6309630be3fcea02fcd54ff72df3bd08b3e4358b3256d389a42aca375552279a249e9bc9ddb5e4081f3912b6e4f084e7de98cec2d0a2f7fa639cb059534ad68bd92fe361224a6de105cfcbc53e8a1b9d3edd98fa24c37d9137f14865d6653b50adc2490f2b83658dd711871dc90954791234cba8a8a0a93d | 0x415a6c4d7a37474f763070417057797738706e53353238 | 0x415a6c4d7a37474f763070417057797738706e53353238 | 0x415a6c4d7a37474f763070417057797738706e53353238 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0x4d3921417c4e223f455321417c4e223d315921417c4e22392f572142457b57413f213b50 | 0 | ||||||||
109 | 44 | 44 | 12 | 1 | 0x3230313320303920313620313220323220313820313737 | 0x32363632343834373730 | 0x00000176785e7d904d4bc3401086fd31614f4bd84fb3390c36d554526db690b4355e4241dd28a9fd403428fdefdd09bdd8422fb3c3ec3bcfbc339208e02ca64c1209455697699ee4659ddd5136259a3243ae41e06f044ae16b8063f5069272f5f5adc2582e36b76dbc7313b69c57ea07fb86a8f00443520c230cf790ccb9d39b695e8f3bbb5b34a322ad44bb76d8905da28d8f931f10f308bcb73301c5b594a1e65a19c3751c51151151a26650fcdba47e7fe9c26ed5e220fb76b6a475d0ae3f7b1bb641b4fd38d33c79ae24ae823f49663edd53c166bfc43d9f141a7f4c546efb1b6d5f7d1e04c1a9d3e0ea0093066062 | 0x415631673570504e5f4a784f72576846534559326c6f67 | 0x41546d7476342e39335770436c3972674d306156593477 | 0x41546d7476342e39335770436c3972674d306156593477 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0x4d3921417c4e224f314329434f21417c4e22392f213b4a | 0 | ||||||||
104 | 66 | 66 | 10 | 1 | 0x3230313320303920313620313220323220313820313932 | 0x34323031383230303636 | 0x000004e6785ebd545b73a23014de1fe3f8e474c225161e981d5181d0821042405e9c022d82c1daae82faeb37693bd3daddf6611f9687c34c3897ef728232940d09a823a00c1523422b32f7273e59a1d9aa2e8f57c7968d40308423a00dc7862cb2ae8df158bc354312a73f8d49a9478834d25d07d17e9c374be7991e579aa83345c64c84b9089608f67705e8bb8feedbe41bd1e696a316303c4395a0a25c4109aa9aa6f067a45e0f255be4c844c435272832b7a63121edbe53af7425d94d99fe5c79e08e2ed55e40dda1573e4faff15e5474ba11cc74354ffaaa6ce9a990599737a0f622b547b5c9f2d6ef329b1db233a8cb14b7b7a4aad14c5bcdc247adb08f | 0x4164395349546a31617635497436626a59487256785f38 | 0x4164395349546a31617635497436626a59487256785f38 | 0x4164395349546a31617635497436626a59487256785f38 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0x4d3921417c4e224f314329434f21417c4e22392f21417c4e22392f572142457b57413f213b52 | 0 | ||||||||
106 | 44 | 44 | 12 | 1 | 0x3230313320303920313620313220323220313920313735 | 0x383638323931333630 | 0x00000171785e7d504d6bc24010ed8f097b0ab29f261e861ab16bd3ba46eae6102fa2248d1b34542d625bfadfdd092d140fbdcc0cf366de7b33827060b41f5241042cd2d52c310f219d1315d298f48123108194986360d8bd87a4b21f85918d3b96da4df5dbae3c4fec38c5bd114e8c31789a98680c13488a4abd6c5a6673fd783a336bd666a9b34e28fd8fede947f91969a6c03a3b06245342f41453723088d0bd8c08b738335cfc1eb172e5a577d9ef50237bfd7b5a56c3e9fde8daba83b6489939e0ca9fecab06b24d335bef2b44e709542d1675015f82e47ee23be434ff24f5f2a6b1f57f448243f7a3835f174110dc3a0deeae1e5a5f91 | 0x4159653552626e3154554648737631544d614d5a464f45 | 0x41655479594d346a69726446694c46706c647647544449 | 0x41655479594d346a69726446694c46706c647647544449 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0x4d3921417c4e2243294131213b45 | 0 |
I do not recommend accessing directly the tables of the repository because:
1) Data are encrypted and as you can understand SAP will not provide any information that will help you decrypt the data (due to security reasons).
2) Assuming you know someone working for NSA and you are somehow able to decrypt the data both the encryption and the table structure of the repository are subject to change without notice in a future patch.
Accessing repository data should be done over the BOE SDK. THat's the way the BI Platform works anyway.
BTW it is worth it to get familiar with the BOE SDK since it can provide you with flexible solutions also in other cases.
Best regards,
Stratos
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.