tag:blogger.com,1999:blog-82665953373916569832024-02-19T03:42:21.652-08:00ItzERPRajesh Goallahttp://www.blogger.com/profile/17569836097447091527noreply@blogger.comBlogger215125tag:blogger.com,1999:blog-8266595337391656983.post-53815578708206096442015-09-02T05:14:00.001-07:002015-09-02T05:14:21.982-07:00JDB9900267 - Failed to find requested column -- in the table<div dir="ltr" style="text-align: left;" trbidi="on">
<br /></div>
Rajesh Goallahttp://www.blogger.com/profile/17569836097447091527noreply@blogger.com0tag:blogger.com,1999:blog-8266595337391656983.post-23704000621966249562015-08-26T21:48:00.003-07:002015-08-26T21:48:46.996-07:00******** 4742 Payee Control - Payee Pending Approval<div dir="ltr" style="text-align: left;" trbidi="on">
CAUSE . . . . All payments for this payee have been stopped. Critical data has been changed that requires approval before any payments can be processed.<br />
<br />
RESOLUTION. . Approve all changes to the Bank Account Numbers, Payee Name, and Payee Address using the Payee Control system. You will need to contact someone responsible for security in order to process payments for this Payee.</div>
Rajesh Goallahttp://www.blogger.com/profile/17569836097447091527noreply@blogger.com0tag:blogger.com,1999:blog-8266595337391656983.post-88534816800251303792014-09-30T08:49:00.000-07:002014-09-30T09:14:05.036-07:00 Aborting the discovery process. com.jdedwards.database.services.packagelookup.PackageLookupServiceException: PackageLookUpService<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Issue</b><br />
IBM WebSphere cast iron (or for that matter any integration tool) is not able to connect to JDE.<br />
JAS.log contains below errors ...<br />
<b><br /></b>
<b>Log Snippet</b><br />
30 Sep 2014 08:35:54,313 [APP ] - [JDBJ] SELECT EMPATHCD,EMDL01,EMMKEY,EMSERSHP,EMSTCE,EMMRGOPT,EMRLS,EMJDEDBTYP,EMDATS,EMINSPAR,EMUNCFLG,EMPID,EMUSER,EMUPMJ,EMUPMT,EMDBSY FROM SY910.F00942 WHERE (EMPATHCD = ? )<br />
30 Sep 2014 08:35:54,314 [APP ] - [JDBJ] SQL statement parameter marker values are : <br />
30 Sep 2014 08:35:54,314 [APP ] - [JDBJ] Param1 : DV910_Types.VARCHAR,<br />
30 Sep 2014 08:35:54,330 [MANDATORY] - [JDBJ] This server is using Automatic Package discovery.<br />
30 Sep 2014 08:35:54,330 [MANDATORY] - [JDBJ] The serialized object database will be maintained by the system.<br />
30 Sep 2014 08:35:54,341 [APP ] - [JDBJ] SELECT LMLL,LMRLS,LMPATHCD,LMENHV01 FROM SY910.F00941 WHERE (LMLL = ? )<br />
30 Sep 2014 08:35:54,341 [APP ] - [JDBJ] SQL statement parameter marker values are : <br />
30 Sep 2014 08:35:54,342 [APP ] - [JDBJ] Param1 : DV910_Types.VARCHAR,<br />
30 Sep 2014 08:35:54,359 [APP ] - [JDBJ] SELECT OMENHV,OMDATP,OMSRVR,OMDATB,OMOOWN,OMDLLNAME,OMLL,OMLIB,OMOMUI,OMOMTO,OMOMDS,OMOMJD,OMOMCC,OMDSTP,OMPID,OMDATUSE,OMUSER,OMOCM1,OMJOBN,OMOCM2,OMUPMJ,OMOCM3,OMUPMT,OMOCMA,OMOCMB,OMOCMC,OMOCMDSC,OMSVRPORT,OMDATB2,OMLOBFLG,OMUNICODE,OMDBINST FROM SY910.F98611 WHERE (OMDATP = ? )<br />
30 Sep 2014 08:35:54,359 [APP ] - [JDBJ] SQL statement parameter marker values are : <br />
30 Sep 2014 08:35:54,360 [APP ] - [JDBJ] Param1 : LOCAL_Types.VARCHAR,<br />
30 Sep 2014 08:35:54,369 [APP ] - [JDBJ] Discovered the enterprise server at host <LOCAL>, port <6016>.<br />
30 Sep 2014 08:35:54,372 [APP ] - [JDBJ] SELECT MDMCHRCDNM FROM SY910.F9651 WHERE ((MDMKEY = ? AND MDPORTNUM = ? AND MDMCHDETTYP = ? ))<br />
30 Sep 2014 08:35:54,372 [APP ] - [JDBJ] SQL statement parameter marker values are : <br />
30 Sep 2014 08:35:54,373 [APP ] - [JDBJ] Param1 : LOCAL_Types.VARCHAR,<br />
30 Sep 2014 08:35:54,373 [APP ] - [JDBJ] Param2 : 6016_Types.NUMERIC,<br />
30 Sep 2014 08:35:54,374 [APP ] - [JDBJ] Param3 : 32_Types.VARCHAR,<br />
30 Sep 2014 08:35:54,384 [APP ] - [JDBJ] Deployment status on the enterprise server is <UNDEFINED>.<br />
30 Sep 2014 08:35:54,385 [WARN ] - [JDBJ] Deployment status on the enterprise server is <UNDEFINED>. Assuming the package is functional.<br />
30 Sep 2014 08:35:54,387 [APP ] - [JDBJ] SELECT SKSERSHP FROM SY910.F96511 WHERE ((SKMKEY = ? AND SKPORTNUM = ? AND SKPATHCD = ? AND SKMCHDETTYP = ? ))<br />
30 Sep 2014 08:35:54,387 [APP ] - [JDBJ] SQL statement parameter marker values are : <br />
30 Sep 2014 08:35:54,388 [APP ] - [JDBJ] Param1 : LOCAL_Types.VARCHAR,<br />
30 Sep 2014 08:35:54,388 [APP ] - [JDBJ] Param2 : 6016_Types.NUMERIC,<br />
30 Sep 2014 08:35:54,389 [APP ] - [JDBJ] Param3 : DV910_Types.VARCHAR,<br />
30 Sep 2014 08:35:54,389 [APP ] - [JDBJ] Param4 : 31_Types.VARCHAR,<br />
30 Sep 2014 08:35:54,399 [SEVERE] - [JDBJ] For server <LOCAL>, port <6016>, pathcode <DV910>, failed to find the deployed package. Aborting the discovery process. com.jdedwards.database.services.packagelookup.PackageLookupServiceException: PackageLookUpService: Could not find attribute <31> in table F96511 for host <LOCAL>, port <6016>, pathcode <DV910>.<br />
<div>
<br /></div>
<div>
<b>Analysis</b></div>
<div>
<b><br /></b></div>
<div>
The environment specified in the JDBj.ini is 'DV910'.<br />
<a name='more'></a></div>
<div>
So, based on the DEFAULT OCM mappings for BSFN, LOCAL data source has been picked up and the subsequent logic expected entries for 'LOCAL' machine in F9651/F96511 tables</div>
<div>
<br /></div>
<div>
<div>
[JDBj-BOOTSTRAP SESSION]</div>
<div>
environment=DV910</div>
</div>
<div>
<br /></div>
<div>
As there will not be any packages (type 31 record) for LOCAL machine, connectivity to JDE failed</div>
<div>
<br /></div>
<div>
<b>Solution</b></div>
<div>
Now, the environment in the JDBj.ini is changed to JDV910 and connection is successful</div>
<div>
<div>
<br /></div>
<div>
[JDBj-BOOTSTRAP SESSION]</div>
<div>
environment=JDV910</div>
</div>
<div>
<br /></div>
<div>
If you come across this issue with JDV910 as well, perform a full package build and try again</div>
</div>
Rajesh Goallahttp://www.blogger.com/profile/17569836097447091527noreply@blogger.com0tag:blogger.com,1999:blog-8266595337391656983.post-34371666557985482662014-09-20T01:45:00.000-07:002014-09-20T02:17:20.986-07:00Disaster Recovery Plan (DRP) <div dir="ltr" style="text-align: left;" trbidi="on">
<b>Multiple Data Centers</b><br />
Companies usually operate two or more geographically separate data centers (primary data center and secondary data center) to make sure business continues as usual in the event of a disaster at one of the data centers.In addition to traditional backups, real-time data from primary data center will be constantly replicated to the secondary data center.<br />
In the event of a disaster, the infrastructure at the secondary data center is enabled to run the business.<br />
<br />
<b>Disaster Recovery Plan</b><br />
Disaster recovery plan (DRP) is a documented process or set of procedures to recover and protect a business IT infrastructure in the event of a disaster. Organizations conduct regular (usually annual) drills to<br />
1) Ensure DRP is current and valid<br />
2) Understand the time taken for recovery and switching back to primary data center (assuming Primary data center has returned to normalcy)<br />
<a name='more'></a><br />
3) Understand the resources required to implement the plan<br />
4) Ensure all team members fully understand their duties is implementing the plan<br />
<br />
<br />
<br />
<b>Questions for discussion (considering JD Edwards environments)</b><br />
1) Is my DRP complete by including just the production database as part of the replication from primary to secondary data center?<br />
2) Is it required to include Central objects databases of all the non-production environments as part of the DRP?<br />
<br />
Please share your experiences</div>
Rajesh Goallahttp://www.blogger.com/profile/17569836097447091527noreply@blogger.com0tag:blogger.com,1999:blog-8266595337391656983.post-73804241490110822262014-09-19T10:41:00.001-07:002014-09-19T10:41:36.406-07:00OOW 2014 - JD Edwards: Focus on Solutions for Projects and Services<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: #333333; font-family: Arial, Verdana, sans-serif;">JD Edwards: Focus on Solutions for Projects and Service</span><span style="color: #333333; font-family: Arial, Verdana, sans-serif;">s</span><span style="color: #333333; font-family: Arial, Verdana, sans-serif; font-weight: bold;"><span style="font-size: large;"> </span><a href="http://bit.ly/1wwHtdF">http://bit.ly/1wwHtdF</a></span></div>
Rajesh Goallahttp://www.blogger.com/profile/17569836097447091527noreply@blogger.com0tag:blogger.com,1999:blog-8266595337391656983.post-27496402077648956832014-09-19T08:26:00.002-07:002014-09-20T02:17:35.904-07:00JDE: Issue with tables triggers initiated from web servers<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Issue</b><br />
Table level event rules implemented on the table F0006 is not working as expected when DML operations are initiated from web server.<br />
<br />
<b>Observation</b><br />
Table triggers initiated from Batch/Enterprise/FAT client/Web development clients work properly. After troubleshooting the logs, we have concluded that COK didn't get the request from JAS<br />
<div>
<br />
<a name='more'></a><br /></div>
<b>Fix</b><br />
1) MOS says this is a known issue with auto generation of serialized specifications and been fixed in the TR 9.1.4.4.So upgrade to tools release 9.1.4.4<br />
2) As a work around, generate the serialize specifications for the tables manually<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhZWLf7jRaIauLl6uINTX8sN4xX-4uiMbr6AHn9IpSiS4ZMQAI-IvHqPP3Hr7N1U2t_-QXZqEG_JZ3Na_M8wq_l-euSAz3GzHO_U4k-DJt3WzRMJPOM29ZTm3ZZC9e-8SDQoKLf8e0z1UUB/s1600/F0901_AFTER.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><br /></a></div>
<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg8EzYXRzB8Qn7bhz-dXuEuLKCIx5_JNgvwusUArYxraizo-139dJcK8M6amiWw6PhHqQMeb_jdyAyctMbU5oBtbSr2aPb6sh1Zjl1Yp0Cy70bYvLaiz3I4beVGSl9RmCbCRm_J6jLRahpD/s1600/F0901.png" imageanchor="1" style="clear: left; margin-bottom: 1em; margin-left: auto; margin-right: auto;"><img alt="" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg8EzYXRzB8Qn7bhz-dXuEuLKCIx5_JNgvwusUArYxraizo-139dJcK8M6amiWw6PhHqQMeb_jdyAyctMbU5oBtbSr2aPb6sh1Zjl1Yp0Cy70bYvLaiz3I4beVGSl9RmCbCRm_J6jLRahpD/s1600/F0901.png" height="124" title="JDE Web Specifications (Issue exists)" width="320" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><b>Data from F989999 - Issue exists</b></td></tr>
</tbody></table>
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhZWLf7jRaIauLl6uINTX8sN4xX-4uiMbr6AHn9IpSiS4ZMQAI-IvHqPP3Hr7N1U2t_-QXZqEG_JZ3Na_M8wq_l-euSAz3GzHO_U4k-DJt3WzRMJPOM29ZTm3ZZC9e-8SDQoKLf8e0z1UUB/s1600/F0901_AFTER.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img alt="" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhZWLf7jRaIauLl6uINTX8sN4xX-4uiMbr6AHn9IpSiS4ZMQAI-IvHqPP3Hr7N1U2t_-QXZqEG_JZ3Na_M8wq_l-euSAz3GzHO_U4k-DJt3WzRMJPOM29ZTm3ZZC9e-8SDQoKLf8e0z1UUB/s1600/F0901_AFTER.png" height="176" title="JDE F98999 table trigger issue" width="320" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><b>Data from F989999 after manual generation of specs - Works as expected</b></td></tr>
</tbody></table>
<div>
<br /></div>
</div>
Rajesh Goallahttp://www.blogger.com/profile/17569836097447091527noreply@blogger.com0tag:blogger.com,1999:blog-8266595337391656983.post-3965656720902305332014-09-19T05:02:00.000-07:002014-09-20T05:05:38.734-07:00Oracle Database In-Memory Success Stories - JD Edwards with Lyle Ekdahl<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="-webkit-text-stroke-width: 0px; clear: both; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; margin: 0px; orphans: auto; text-align: center; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
</div>
<br />
<div class="separator" style="-webkit-text-stroke-width: 0px; clear: both; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; margin: 0px; orphans: auto; text-align: right; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<iframe allowfullscreen='allowfullscreen' webkitallowfullscreen='webkitallowfullscreen' mozallowfullscreen='mozallowfullscreen' width='320' height='266' src='https://www.youtube.com/embed/HAB8N0fvedw?feature=player_embedded' frameborder='0'></iframe></div>
<div class="" style="clear: both; text-align: left;">
<span style="background-color: white; color: #333333; font-family: arial, sans-serif; font-size: x-small; line-height: 17px;"><br /></span></div>
<div class="" style="clear: both; text-align: left;">
<span style="background-color: white; color: #333333; font-family: arial, sans-serif; font-size: x-small; line-height: 17px;">Lyle Ekdahl, Senior Vice President and General Manager, JD Edwards </span><span style="background-color: white; color: #333333; font-family: arial, sans-serif; font-size: x-small; line-height: 17px;">talks about the impact and benefits of Oracle 12c Database In-Memory successes</span></div>
<div class="" style="clear: both; text-align: left;">
<span style="background-color: white; color: #333333; font-family: arial, sans-serif; font-size: x-small; line-height: 17px;"><br /></span></div>
<div class="" style="clear: both; text-align: left;">
<b>Highlights of Lyle Ekdahl's speech</b></div>
<div class="" style="clear: both; text-align: left;">
1) Drastic improvement in operational analysis performance, in order of 1000 times.</div>
<div class="" style="clear: both; text-align: left;">
2) Seem less integration with existing systems</div>
<div class="" style="clear: both; text-align: left;">
3) Oracle database 12c In-Memory option is not a replacement for traditional BI systems, but it provides analytic type features inline with-in the ERP systems</div>
</div>
Rajesh Goallahttp://www.blogger.com/profile/17569836097447091527noreply@blogger.com0tag:blogger.com,1999:blog-8266595337391656983.post-58345867706202019702014-07-09T06:33:00.003-07:002014-09-18T06:16:28.902-07:00Microsoft eBooks Collection<div dir="ltr" style="text-align: left;" trbidi="on">
<a class="short-url" href="http://bit.ly/1n8iHxX" style="background-color: #f3f8fb; color: black; display: block; font-family: 'Source Sans Pro', sans-serif; font-size: 13px; line-height: 21px; margin: 0px; min-width: 150px; outline: 0px; padding: 0px; position: relative; text-decoration: none; width: 150px;">Microsoft eBooks collection </a><a class="short-url" href="http://bit.ly/1n8iHxX" style="color: black; display: inline !important; margin: 0px; min-width: 150px; outline: 0px; padding: 0px; position: relative; text-decoration: none; width: 150px;">bit.ly/1n8iHxX</a></div>
Rajesh Goallahttp://www.blogger.com/profile/17569836097447091527noreply@blogger.com0tag:blogger.com,1999:blog-8266595337391656983.post-52530075094471379132011-10-14T05:54:00.000-07:002011-10-14T20:10:53.703-07:00JDE : COB0000012 - GetProcAddress failed<div dir="ltr" style="text-align: left;" trbidi="on">
1888/3672 WRK:Starting jdeCallObject Fri Oct 14 16:21:16.565001 Jdeobj.c1261<br />
COB0000012 - GetProcAddress failed CCUSTOM.dll function <a href="mailto:_GetFileFromPathMatchingWildcard@12">_GetFileFromPathMatchingWildcard@12</a> Error = 0<br />
<br />
The name of the APIs are mentioned in two places<br />
1) In the JDE BSFN Object ( Mapping to the Template DataStructure)<br />
2) In the c source file.<br />
<br />
<strong>Scenario 1: If this error is seen in the client's JDE.log itself</strong><br />
Make sure the name of the API given in 1) and 2) are same.<br />
In my case, the name given in BSFN Object(GUI) is GetFileFromPathMatchingWildcard<br />
But the name given in the BSFN .c file is GetFileFromPathMatchingWildcardXXX().Due to this the CCUSTOM dll is not updated with the name given in the JDE object.<br />
<br />
<strong>Scenario 2: Working in FAT client, but not on Enterprise Server</strong><br />
The BSFN is not properly deployed on the Server <br />
<br />
<br />
Hope it helps : )</div>Rajesh Goallahttp://www.blogger.com/profile/17569836097447091527noreply@blogger.com2tag:blogger.com,1999:blog-8266595337391656983.post-11670186463520735082011-08-29T20:24:00.000-07:002011-08-29T20:30:06.761-07:00Preventing Check Fraud : Positive Pay<div dir="ltr" style="text-align: left;" trbidi="on">
Check fraud is one of the common payment frauds.In order to avoid this, ERP softwares usually go for Positive Pay file.<br />
<br />
<b>Frauds?</b> <br />
Some of the frauds that can happen with checks are<br />
1) Changing the amount the on the check<br />
2) Counterfeiting the checks<br />
<br />
<b>Positive Pay/Enhanced Positive Pay</b>It is a mechanism that requires companies to send a text file with the list of checks issued to the bank <br />
This flat file contain information like<br />
1) Payee Name<br />
2) Check Date<br />
3) Check Amount etc.<br />
<br />
So when the Payee takes check to the bank, bank person will match the check with the information in the flat file before releasing the funds.If any mismatch is found, an exception is raised and sent to the Company...</div>
Rajesh Goallahttp://www.blogger.com/profile/17569836097447091527noreply@blogger.com0tag:blogger.com,1999:blog-8266595337391656983.post-69852975680627177762011-08-26T05:55:00.000-07:002011-08-26T05:55:28.165-07:00JDE : Export the output data in Excel format<div dir="ltr" style="text-align: left;" trbidi="on">
The default output of a report in JDE is PDF file.The report can be designed to generate csv ( along with PDF) as well. But at times an excel file is required instead of csv.<br />
<br />
Here is the way<br />
1) Write the Data to a abc.txt file using one of the BSFN APIs.The fields/columns have to separated by TAB.<br />
2) Now after writing all the data, rename the file to abc.xls<br />
3) Here comes the catch, JDE tool set does not allow to type TAB character.So you can open notepad, press TAB key, copy it and paste in JDE. :)</div>
itzERPhttp://www.blogger.com/profile/11059044726172884013noreply@blogger.com0tag:blogger.com,1999:blog-8266595337391656983.post-15535514417220853352011-08-23T07:00:00.000-07:002011-08-23T07:04:35.003-07:00JDE NO DATA SELECTION INFORMATION FOUND<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Error Message on the Pop up Message</b><br />
NO DATA SELECTION INFORMATION FOUND<br />
Data Selection information for this report has not been generated. Please contact your administrator<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCjxidrUBUoVKx-1CnYRyWasvohODenR8CtGJr7Y-j3GPzrBRIpWnQFAtyVRjBbl7EsJPEtuMIDaxqpfYFU042oGx_ua5_XpMYRlJ_l13D6r7r3wqfLMJGz0Ed5ONRuxhbUDYLJWmMbxwM/s1600/itzerp_JDE.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="176" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCjxidrUBUoVKx-1CnYRyWasvohODenR8CtGJr7Y-j3GPzrBRIpWnQFAtyVRjBbl7EsJPEtuMIDaxqpfYFU042oGx_ua5_XpMYRlJ_l13D6r7r3wqfLMJGz0Ed5ONRuxhbUDYLJWmMbxwM/s640/itzerp_JDE.png" width="640" /></a></div>
<br />
<b>Error Messages in jas logs</b><br />
[SPEC_NOT_FOUND] Unable to find OneWorld specification for REPORTSEL-R550411PT-KJG0001 (and/or)<br />
[SPEC_NOT_FOUND] Unable to find OneWorld specification for PRINTINFO-R550411PT-KJG0001 (and/or)<br />
[SPEC_NOT_FOUND] Unable to find OneWorld specification for REPORTSEQ-R550411PT-KJG0001 (and/or)<br />
[SPEC_NOT_FOUND] Unable to find OneWorld specification for REPORTINFO-R550411PT-KJG001<br />
<br />
<b>Release : E811</b><br />
<b><br /></b><br />
<b>Problem/Solution : </b><br />
The serialized Specs generated by the Generator were inserted in to F989999 in Data Source A. But JAS server is looking into F989999 from a Data Source B.<br />
So make sure both Generator and HTML Server are looking into the same Data Source</div>
Rajesh Goallahttp://www.blogger.com/profile/17569836097447091527noreply@blogger.com2tag:blogger.com,1999:blog-8266595337391656983.post-49148086157655406642011-07-26T02:54:00.000-07:002011-08-23T07:37:34.417-07:00JDE Retrieve of UBE file failed<div dir="ltr" style="text-align: left;" trbidi="on">
<div closure_uid_ae176r="61">
<em closure_uid_ae176r="63">UBE: Retrieve of UBE file failed. The file may not exist on Enterprise Server.</em></div>
<div closure_uid_ae176r="62">
If you see the above message and the output is supposed to be present,check the 'Suppress All Output' flag under File-&gt;Report Properties option.Make sure it is not cheked.<br />
<br />
You can also find the following message in the log : --UBE--[1]-- Output is disabled. No PDF file will be created for this report. </div>
</div>
Rajesh Goallahttp://www.blogger.com/profile/17569836097447091527noreply@blogger.com0tag:blogger.com,1999:blog-8266595337391656983.post-37566120864845346632011-07-11T07:32:00.000-07:002011-07-16T23:58:33.612-07:00JDE MICR E13-B font<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZwgK6zX9XLFRuqKMSdXPKtJJ0KSPy3LoJ8q9sXW3nwvXjUcWtF9NsQ8bVGDWk_oAClrJuM6SRsawA4Fvz7NsvYcHHZpOrPdFN0EJR510phG50dWPWcXbY1mjnjO3w4jRIREYtMF4fQz5B/s1600/micr.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="21" m$="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZwgK6zX9XLFRuqKMSdXPKtJJ0KSPy3LoJ8q9sXW3nwvXjUcWtF9NsQ8bVGDWk_oAClrJuM6SRsawA4Fvz7NsvYcHHZpOrPdFN0EJR510phG50dWPWcXbY1mjnjO3w4jRIREYtMF4fQz5B/s200/micr.png" width="200" /></a></div>
I was developing few cheque/check(BoA and BoM) printing applications in JDE.I came across the gnuMICR font from the website : http://sandeen.net/GnuMICR/ and used it for writing the micr line in the check/cheque.<br />
The micr line passed both the bank tests.<br />
<br />
Incase you are developing any <u>MICR E-13B</u> based check reports in JDE, see if this font meets your requirement.<br />
Speak to the developer/author of the Font : Mr Eric Sandeen.(Email id is available in the web page) for the TnC of usage and more information<br />
<br />
<span style="font-size: x-small;">Note: This font may or maynot solve your purpose.Just give a try</span><br />
<br />
<strong><u><span style="color: black;">Little More</span></u></strong><br />
<ul>
<li>MICR stands for Magnetic Ink Character Recognition.It is a technology that allows computers to read information printed on checks</li>
<li>Unlike Barcode information,MICR information is human readable.</li>
<li>Popular MICR font standards are E-13B and CMC-7</li>
<li>E-13B is used for cheque printing in US,Canada,UK,Australia,African Countries,India,China etc.,</li>
<li>CMC-7 is used in France,Israel,most of the South American countries etc.,</li>
<li>E-13B Character set contains 10 numerals(0-9) and 4 control characters.</li>
<li>CMC-7 contains 10 numerals and 5 control characters</li>
</ul>
Rajesh Goallahttp://www.blogger.com/profile/17569836097447091527noreply@blogger.com0tag:blogger.com,1999:blog-8266595337391656983.post-13000840423378744172011-06-01T00:43:00.000-07:002011-07-19T05:23:12.084-07:00JDE Reports Questions Contd .....<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: justify;">
<strong>Question : </strong>Suppose you are creating a copy of version JDE0001.Assume JDE0001 is modified in the Development client machine.Now when you copy the JDE0001, which one will be get preference?One in the client machine or the one from Server</div>
<div style="text-align: justify;">
<strong>Answer </strong>: Client will get preference.If client doesnt have the specs fot the version,then Server version will be copied</div>
<br /><strong>Is it possible to define Processing Options at Version Level?</strong><br />
Yes</div>
Rajesh Goallahttp://www.blogger.com/profile/17569836097447091527noreply@blogger.com0tag:blogger.com,1999:blog-8266595337391656983.post-68518492082873716322011-06-01T00:02:00.000-07:002011-06-01T00:04:20.465-07:00JD Edwards EnterpriseOne Implementation Libraries<div style="TEXT-ALIGN: left" dir="ltr" trbidi="on"><br /><ul><br /><li><a href="http://download.oracle.com/docs/cd/E13781_01/jded/html/docset.html"><strong>JD Edwards EnterpriseOne 9.0 Implementation Guides</strong></a></li></ul></div>itzERPhttp://www.blogger.com/profile/11059044726172884013noreply@blogger.com0tag:blogger.com,1999:blog-8266595337391656983.post-64843368539380778142011-05-16T08:24:00.000-07:002011-05-16T08:33:04.208-07:00Displaying images on Reports in JDE<div dir="ltr" style="text-align: left;" trbidi="on"><b>Does E1 support embedding images on reports? We're not asking about BI pubilisher</b><br />
JDE does not support<b> </b>embedding images directly on the report.The alternate way is to create a custom font using font creation tools and add that image to a report constant in RDA.<br />
Steps at a high level <br />
<ol style="text-align: left;"><li>Create a new font(<b>Itzlogo</b>) and associate the image to one of the character, say <b>B</b></li>
<li>Save the font and install it to the windows\fonts folder</li>
<li>Now open RDA and add Insert report constant at the place where you wish to have the image/logo/ signature.</li>
<li>In the Variable Name enter the value say 'B'.Navigate to Font/Color tab.. choose the itzlogo font and click ok.</li>
<li>The image will appear on the design aid....... Run the report to see the image now.</li>
</ol>Some of types of images that are added to the reports: Company logos, special symbols,Signatures ..etc<br />
<ol style="text-align: left;"></ol></div>Rajesh Goallahttp://www.blogger.com/profile/17569836097447091527noreply@blogger.com3tag:blogger.com,1999:blog-8266595337391656983.post-54766138484881169922011-05-04T07:28:00.000-07:002011-05-16T08:34:05.904-07:00Event Rules Vs Named Event Rules<div dir="ltr" style="text-align: left;" trbidi="on"><div style="color: black;"></div><div style="color: black; margin: 0px;"><span class="Apple-style-span" style="font-size: 15px; white-space: pre-wrap;"><b>Event rules</b> are embedded in the specifications of the object. So the scope of usage is limited to that object/application</span></div><div style="margin: 0px;"><span style="background-color: transparent; color: white; font-family: 'Times New Roman'; font-size: 11pt; font-style: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;"><b>Named Event Rules</b></span><span style="background-color: transparent; color: white; font-family: 'Times New Roman'; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;"><span style="color: black;"> on the other hand are outside the applica</span>tion. Hence the logic part of NERs are reusable</span></div></div>Rajesh Goallahttp://www.blogger.com/profile/17569836097447091527noreply@blogger.com0tag:blogger.com,1999:blog-8266595337391656983.post-81318740536100773242011-05-04T07:15:00.000-07:002011-08-23T07:39:52.927-07:00About Reports in JD Edwards EnterpriseOne<div dir="ltr" style="text-align: left;" trbidi="on">
<span class="Apple-style-span" style="font-size: 15px; font-weight: bold; white-space: pre-wrap;">Sections in a Report</span><br />
<div style="background-color: transparent;">
<span style="background-color: transparent; font-family: 'Times New Roman'; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">1) <span class="Apple-tab-span" style="white-space: pre;"> </span>Report Header</span><br />
<span style="background-color: transparent; font-family: 'Times New Roman'; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">2) <span class="Apple-tab-span" style="white-space: pre;"> </span>Page Header</span><br />
<span style="background-color: transparent; font-family: 'Times New Roman'; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">3) <span class="Apple-tab-span" style="white-space: pre;"> </span>Detail Sections</span><br />
<span style="background-color: transparent; font-family: 'Times New Roman'; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;"> a. Columnar section</span><br />
<span style="background-color: transparent; font-family: 'Times New Roman'; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;"> b. Group section</span><br />
<span style="background-color: transparent; font-family: 'Times New Roman'; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;"> c. Tabular section</span><br />
<span style="background-color: transparent; font-family: 'Times New Roman'; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">4) <span class="Apple-tab-span" style="white-space: pre;"> </span>Level break Header section</span><br />
<span style="background-color: transparent; font-family: 'Times New Roman'; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">5) <span class="Apple-tab-span" style="white-space: pre;"> </span>Level break Footer section</span><br />
<span style="background-color: transparent; font-family: 'Times New Roman'; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">6) <span class="Apple-tab-span" style="white-space: pre;"> </span>Page Footer section</span><br />
<span style="background-color: transparent; font-family: 'Times New Roman'; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">7) <span class="Apple-tab-span" style="white-space: pre;"> </span>Report Footer section</span><br />
<span style="background-color: transparent; font-family: 'Times New Roman'; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;"> </span><br />
<span class="Apple-style-span" style="font-size: 15px; white-space: pre-wrap;"></span><span style="background-color: transparent; font-family: 'Times New Roman'; font-size: 11pt; font-style: normal; font-weight: bold; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Questions</span></div>
<div style="background-color: transparent;">
<span style="background-color: transparent; font-family: 'Times New Roman'; font-size: 11pt; font-style: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;"><b>How many numbers detail sections possible in a report template?</b></span><br />
<span style="background-color: transparent; font-family: 'Times New Roman'; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Multiple. But the physical page size of report template should not exceed 45 inches in length and width. Report template that exceeds this limit might faces problems at runtime…</span><br />
<span style="background-color: transparent; font-family: 'Times New Roman'; font-size: 11pt; font-style: normal; font-weight: bold; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;"><br />
</span></div>
<div style="background-color: transparent;">
<span style="background-color: transparent; font-family: 'Times New Roman'; font-size: 11pt; font-style: normal; font-weight: bold; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">How many detail sections can be added in a report template using report director?</span><br />
<span style="background-color: transparent; font-family: 'Times New Roman'; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Using the Director, only one detail section can be inserted in the report template. Later RDA can be used to enhance the report template and add extra detail sections</span><br />
<span style="background-color: transparent; font-family: 'Times New Roman'; font-size: 11pt; font-style: normal; font-weight: bold; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;"><br />
</span></div>
<div style="background-color: transparent;">
<span style="background-color: transparent; font-family: 'Times New Roman'; font-size: 11pt; font-style: normal; font-weight: bold; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">How many numbers (max) of Page Header/Page Footer sections possible in a report template?</span><br />
<span style="background-color: transparent; font-family: 'Times New Roman'; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Only one</span><br />
<span style="background-color: transparent; font-family: 'Times New Roman'; font-size: 11pt; font-style: normal; font-weight: bold; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;"><br />
</span></div>
<div style="background-color: transparent;">
<span style="background-color: transparent; font-family: 'Times New Roman'; font-size: 11pt; font-style: normal; font-weight: bold; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">How many numbers (max) of Report Header/Report Footer sections possible in a report template?</span><br />
<span style="background-color: transparent; font-family: 'Times New Roman'; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Only one</span><br />
<span style="background-color: transparent; font-family: Calibri; font-size: 11pt; font-style: normal; font-weight: bold; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;"><br />
</span></div>
<div style="background-color: transparent;">
<span style="background-color: transparent; font-family: Calibri; font-size: 11pt; font-style: normal; font-weight: bold; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Can a business view be attached to a Page header section?</span><br />
<span style="background-color: transparent; font-family: Calibri; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">No. Business views can be attached to details sections only</span><br />
<span style="background-color: transparent; font-family: Calibri; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;"></span><br />
<span style="background-color: transparent; font-family: Calibri; font-size: 11pt; font-style: normal; font-weight: bold; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">what is the default font used to generate PDF reports in E1?</span><br />
<span style="background-color: transparent; font-family: Calibri; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Arial</span><br />
<span style="background-color: transparent; font-family: Calibri; font-size: 11pt; font-style: normal; font-weight: bold; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;"><br />
</span></div>
<div style="background-color: transparent;">
<span style="background-color: transparent; font-family: Calibri; font-size: 11pt; font-style: normal; font-weight: bold; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Is it possible to print the attachments that are inserted in the report?</span><br />
<span style="background-color: transparent; font-family: Calibri; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">No. They are just useful to explain the functionality of the report, any special logic used, documenting the changes etc.,</span><br />
<span style="background-color: transparent; font-family: 'Times New Roman'; font-size: 11pt; font-style: normal; font-weight: bold; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;"><br />
</span></div>
<div style="background-color: transparent;">
<span style="background-color: transparent; font-family: 'Times New Roman'; font-size: 11pt; font-style: normal; font-weight: bold; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">The properties and format of report headers and footers and of page headers and footers are similar to which detail section?</span><br />
<span style="background-color: transparent; font-family: 'Times New Roman'; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Group section</span><br />
<span style="background-color: transparent; font-family: Calibri; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;"> </span><br />
<span class="Apple-style-span" style="font-family: Arial;"><span class="Apple-style-span" style="font-size: 21px; white-space: pre-wrap;"><b></b></span></span><span style="background-color: transparent; font-family: Arial; font-size: 16pt; font-style: normal; font-weight: bold; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Report Templates Vs Batch Versions</span><br />
<span style="background-color: transparent; font-family: 'Times New Roman'; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Report templates are master specifications of the report. It defines the data used, how the data is</span><br />
<span style="background-color: transparent; font-family: 'Times New Roman'; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Selected , sorted, displayed, and formatted etc.</span><br />
<span style="background-color: transparent; font-family: 'Times New Roman'; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Batch versions read the master specifications from the associated report template and over ride one or more specification of the report template like:</span><br />
<span style="background-color: transparent; font-family: 'Times New Roman'; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">• Section layout</span><br />
<span style="background-color: transparent; font-family: 'Times New Roman'; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">• Section data selection</span><br />
<span style="background-color: transparent; font-family: 'Times New Roman'; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">• Section event rules</span><br />
<span style="background-color: transparent; font-family: 'Times New Roman'; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">• Section database output</span><br />
<span style="background-color: transparent; font-family: 'Times New Roman'; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">• Section sort sequence</span><br />
<span style="background-color: transparent; font-family: 'Times New Roman'; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">This concept allows creating requirement specific reports (versions) without touching the Master (i.e Report Template). Basically you create one report template and create multiple version by overriding the specifications.</span><br />
<span style="background-color: transparent; font-family: 'Times New Roman'; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Report Power points:</span><br />
<span style="background-color: transparent; font-family: Arial; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">· <span class="Apple-tab-span" style="white-space: pre;"> </span></span><span style="background-color: transparent; font-family: 'Times New Roman'; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Report template is a Master specification</span><br />
<span style="background-color: transparent; font-family: Arial; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">· <span class="Apple-tab-span" style="white-space: pre;"> </span></span><span style="background-color: transparent; font-family: 'Times New Roman'; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Batch version is a child i.e business need based customization of the Master</span><br />
<span style="background-color: transparent; font-family: 'Times New Roman'; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;"> </span><br />
<span style="background-color: transparent; font-family: 'Times New Roman'; font-size: 11pt; font-style: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;"> </span></div>
</div>
Rajesh Goallahttp://www.blogger.com/profile/17569836097447091527noreply@blogger.com0tag:blogger.com,1999:blog-8266595337391656983.post-53672889550676880472011-03-30T01:12:00.001-07:002011-03-30T01:14:52.485-07:00JDBTRG libraries<div dir="ltr" style="text-align: left;" trbidi="on">The trigger logic written on every table in EnterpriseOne will go into one of the JDBTRG* libraries. The following points detail the logic behind classification of tables Names and triggers libraries...<br />
<ol style="text-align: left;"><li><b>JDBTRG1</b> Tables with names up through (Not including) F200000000</li>
<li><b>JDBTRG2</b> Tables F2* up through (Not including) F4*</li>
<li><b>JDBTRG3</b> Tables F5* up through (Not including) F8*</li>
<li><b>JDBTRG4</b> Tables F9* and greater, including FA, etc.,</li>
</ol><br />
</div>Rajesh Goallahttp://www.blogger.com/profile/17569836097447091527noreply@blogger.com0tag:blogger.com,1999:blog-8266595337391656983.post-2320716802839499882010-11-03T04:19:00.000-07:002010-11-03T05:42:04.171-07:00Deadlock Detection using sql server DBCC trace flagsTrace Flags can be used to output the details of deadlocks in a simple way(SQL Server only).They provide the maximum information to identify the root of the problem.The information will be recorded in the sql server' error log.<br />
Enable trace flags 1204/1205 for more information about deadlocks.Refer this page for the list of <a href="http://msdn.microsoft.com/en-us/library/ms188396.aspx">trace flags available in SqlServer 2008</a><br />
<br />
Example to turn on trace flag 1204<br />
<b>DBCC TRACEON (1204,-1)</b><br />
<br />
To see the status of various trace flags and their scope<br />
<b>DBCC TRACESTATUS</b><br />
<br />
Example to turn on trace flag 1204<br />
<b>DBCC TRACEOFF (1204,-1)</b><br />
<br />
In the above example '-1' is to set the scope of trace flag globally<br />
<br />
Now if the dead lock occurs details about the resources, queries invlolved in the lock will be recorded in the sql server Error Log.<br />
<br />
<b>Related</b><br />
<a href="http://itzerp.blogspot.com/2008/10/collecting-or-enabling-odbc-trace.html">Collecting ODBC trace</a>Rajesh Goallahttp://www.blogger.com/profile/17569836097447091527noreply@blogger.com0tag:blogger.com,1999:blog-8266595337391656983.post-20593483153260264072010-08-07T03:15:00.000-07:002010-08-07T03:15:04.451-07:00java.lang.NoSuchMethodError: javax.xml.soap.SOAPFault.setFaultCode(Ljavax/xml/namespace/QName;)Vjava.lang.NoSuchMethodError: javax.xml.soap.SOAPFault.setFaultCode(Ljavax/xml/namespace/QName;)V<br />
<br />
We faced this issue on jdeveloper10g version[not in Jdeveloper11g]<br />
<br />
1. jdeveloper10 already had <b>saaj-api.jar </b>under C:\JDeveloper\webservices\lib directory<br />
This doesn't contain setFaultCode(javax/xml/namespace/QName qname) argument.<br />
It just had setFaultCode(String s) method<br />
<br />
2. From my application I supplied javax.xml.soap_1.3.1.0.jar which contains the method with QName argument.But as jvm already loaded saaj-api.jar ahead of the application supplied one, it is complaining 'java.lang.NoSuchMethodError' exception.<br />
<br />
3. jdeve11g doesn't have this saaj-api.jar in wbservices\lib folder.So it worked.<br />
To resolve the issue for time being, I deleted the saaj-api.jar from the webservices\lib directory to resolve the issue.We have to find the acceptable way....<br />
<br />
Hope you'll like it.Rajesh Goallahttp://www.blogger.com/profile/17569836097447091527noreply@blogger.com1tag:blogger.com,1999:blog-8266595337391656983.post-14499419653929101632010-07-01T23:03:00.000-07:002010-07-01T23:11:51.097-07:00HYT00 Timeout expiredThe query timeout period expires before the data source returns the result set. The timeout period is set through SQLSetStmtOption : SQL_ATTR_QUERY_TIMEOUT.<br />
<br />
For example, if the query timeout is set to 2 seconds, the query execution is canceled at the end of 2 seconds[i.e if execution takes more than 2 seconds]<br />
<br />
Setting the timeout to 0 secs is not recommended, as it will wait forever to get the result set.<br />
<br />
Sample error message : STMT:00 [<b>HYT00</b>][0] [Microsoft][SQL Server Native Client 10.0]<b>Query timeout expired</b> "Rajesh Goallahttp://www.blogger.com/profile/17569836097447091527noreply@blogger.com0tag:blogger.com,1999:blog-8266595337391656983.post-12820190768886411392010-06-28T18:08:00.000-07:002010-06-28T18:08:33.990-07:00[Deployer:149164]The domain edit lock is owned by another session in exclusive mode - hence this deployment operation cannot proceed.<div class="MsoNormal"><jun 2010="" 28,="" 5:53:28="" mdt="" pm=""> <warning> <deployer> <<b>BEA-149124</b>> <failures -="" [deployer:149164]the="" another="" application="" by="" cannot="" deploy="" deployment="" detected="" domain="" edit="" error="" exclusive="" for="" hence="" in="" initiating="" is:="" is="" lock="" mode="" operation="" owned="" proceed.'="" session="" task="" this="" were="" while="" ‘sample’.=""> </failures></deployer></warning></jun></div><div class="MsoNormal">#### Cannot run application sample due to error deploying to IntegratedWebLogicServer.</div><div class="MsoNormal">[05:53:28 PM] ####<span style="mso-spacerun: yes;"> </span>Deployment incomplete.<span style="mso-spacerun: yes;"> </span>####</div><div class="MsoNormal">[05:53:28 PM] Remote deployment failed</div><div class="MsoNormal">[Application sample stopped and undeployed from Server Instance IntegratedWebLogicServer]</div><span style="font-family: "Times New Roman"; font-size: 12.0pt; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-US;"><logger><error> ServletContainerAdapter manager not initialized correctly.</error></logger></span><br />
<span style="font-family: "Times New Roman"; font-size: 12.0pt; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-US;"><br />
</span><br />
<u>Note</u>: I'm using embedded weblogic server [Jdeveloper 11g].<br />
<br />
<b>Solution[Possible]:</b><br />
1.Launch the weblogic admin console application : http://127.0.0.1:7101/console.<br />
If you are running this for the first time,it will take some time.<br />
2. Default user id/password are weblogic/weblogic1.<br />
3.Once you login, click 'activate changes'.<br />
4. Try to deploy your application now. Rajesh Goallahttp://www.blogger.com/profile/17569836097447091527noreply@blogger.com1tag:blogger.com,1999:blog-8266595337391656983.post-89258482206663052742010-06-03T22:24:00.000-07:002010-06-03T22:28:07.260-07:00[28000] [Microsoft][SQL Native Client][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.<b>Error:</b><br />
<span class="Apple-style-span" style="font-size: small;">DIAG [28000] [Microsoft][SQL Native Client][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. (18452) </span><br />
<span class="Apple-style-span" style="font-size: small;">DIAG [08S01] [Microsoft][SQL Native Client]TCP Provider: An existing connection was forcibly closed by the remote host.(10054)</span><br />
<span class="Apple-style-span" style="font-size: small;">DIAG [08S01] [Microsoft][SQL Native Client]Communication link failure (10054)</span><br />
<span class="Apple-style-span" style="font-size: small;"><br />
</span><br />
The above error will generally occur when the 'server authentiction' is set to "Windows Authentication mode'.This means one can login to Sql Server with Windows NT authentication using the network login ID only and not using a logID and password entered by the user.<br />
But the above error can occur even when the 'server authentiction' set to "SQL Server and Windows Authentication mode".One possibilty is when database user is null/empty.<br />
I intentionally passed null(\0) in userID and got the above error in the ODBC trace log.<br />
<br />
<b>Relate<iframe align="left" frameborder="0" marginheight="0" marginwidth="0" scrolling="no" src="http://rcm.amazon.com/e/cm?t=itzerp&o=1&p=8&l=bpl&asins=1556158157&fc1=000000&IS2=1&lt1=_blank&m=amazon&lc1=0000FF&bc1=000000&bg1=FFFFFF&f=ifr" style="align: left; height: 245px; padding-right: 10px; padding-top: 5px; width: 131px;"></iframe>d</b>: <a href="http://itzerp.blogspot.com/2008/10/collecting-or-enabling-odbc-trace.html">Collecting or enabling ODBC trace</a>Rajesh Goallahttp://www.blogger.com/profile/17569836097447091527noreply@blogger.com0