<?xml version="1.0" encoding="UTF-8"?><!-- generator="WordPress/2.9.2" -->
<rss version="0.92">
<channel>
	<title>BWFreak</title>
	<link>http://yangchuang.com/wp22</link>
	<description>knowledge gathering on SAP BW</description>
	<lastBuildDate>Wed, 04 Aug 2010 04:43:21 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	
	<item>
		<title>problem with parameter &#8220;I_SYNCHRONOUS&#8221; or &#8220;I_STIMULATE&#8221;</title>
		<description><![CDATA[March 16, 2009
Ran process chains from Cronacle (Redwood explorer).
Most of the time, everything&#8217;s fine. Occationally, I got the following errors:
ORA-20800: JCS-02138: problem with parameter &#8220;I_SYNCHRONOUS&#8221;
 ORA-01008: not all variables bound
When it happens, the step fails inside Cronacle.
One possible cause is the job I am using didn&#8217;t set the value of &#8220;I_SYNCHRONOUS&#8221; and &#8220;I_STIMULATE&#8221;.
I Found the value of [...]]]></description>
		<link>http://yangchuang.com/wp22/?p=89</link>
			</item>
	<item>
		<title>No resources, immed. processing not possible</title>
		<description><![CDATA[BW loading error due to IDoc not available.
The error can be found by checking we02 on source system:
No resources, immed. processing not possible: Too few free dialog work processes
To resolve:
- From BW side, turn the load status to red, do what should be done when load fails, e.g. reschedule the load with proper setting, or [...]]]></description>
		<link>http://yangchuang.com/wp22/?p=170</link>
			</item>
	<item>
		<title>BW: Error 1 when loading external data</title>
		<description><![CDATA[Although SAP has a pretty long message when you encounter Error 1 , it&#8217;s not to the point enough to make the debugging easier.
In my case, the reason is that the file was open. Close the file, everything was fine.
Diagnosis
Error number 1 occurred when loading external data:
1. Error when reading the file (access rights, file [...]]]></description>
		<link>http://yangchuang.com/wp22/?p=166</link>
			</item>
	<item>
		<title>Using flat file as source or target in a workflow</title>
		<description><![CDATA[The files MUST be on the Job Server machine. If it works, ignore the error message.]]></description>
		<link>http://yangchuang.com/wp22/?p=158</link>
			</item>
	<item>
		<title>Transform is terminated &#8211; error 50505</title>
		<description><![CDATA[SAP BOBJ DataServices Global Address Cleanse transform Canadian Address parsing unknown error 50505 &#038; solution.]]></description>
		<link>http://yangchuang.com/wp22/?p=152</link>
			</item>
	<item>
		<title>Delta extraction stuck on TRFCQOUT table</title>
		<description><![CDATA[While checking the BW load today, I found one delta load was several hours late and was still running in the afternoon. It was doing one single query on TRFCQOUT table.
Checked execution plan, and found it was using a wrong index. Tried re-calculate table stats, index stats, and re-index.
The issue was solved by rebuilding indexes.
There&#8217;s [...]]]></description>
		<link>http://yangchuang.com/wp22/?p=143</link>
			</item>
	<item>
		<title>BWFreak WordPress Upgraded Today</title>
		<description><![CDATA[Reasons for WordPress Upgrade and solutions for issues encountered.]]></description>
		<link>http://yangchuang.com/wp22/?p=126</link>
			</item>
	<item>
		<title>Canadian Address Parsing</title>
		<description><![CDATA[Never thought I&#8217;ll need to parse Canadian address one day, and never thought parsing addresses not easy. Just so that somebody else don&#8217;t need to collect all different kind of addresses again, here&#8217;s a list, and likely to grow.
Suite#/Apt#/House# &#8211; Street# &#8211; Street Name, Postal code
Route#, Postal code
Highway#, Postal code
PO Box#, Postal code
RR#, Postal code 
RR = rural route
LCD [...]]]></description>
		<link>http://yangchuang.com/wp22/?p=122</link>
			</item>
	<item>
		<title>RSRV</title>
		<description><![CDATA[Error with partition when loading
Error:
Communication errors (RFC)
DBIF_RSQL_SQL_ERROR
CX_SY_OPEN_SQL_DB ORA-14400:
inserted partition key does not map to any partition
Internal call code.........: "[RSQL/INSR//BIC/B0000xxxxxx ]"

Solution:
RSRV -&#62; PSA Tables -&#62; Consistency Check for PSA
Error calling number range object for dimension when loading cube
Solution:
1. rsrv &#62; all elementry tests &#62; master data &#62; compare number range and maximum sid &#62; execute. press [...]]]></description>
		<link>http://yangchuang.com/wp22/?p=32</link>
			</item>
	<item>
		<title>BW recordmode</title>
		<description><![CDATA[To get a clear defination of BW recordmode:
SE11, data type RODMUPDMOD -> click Documentation
RODMUPDMOD
____________________________________________________
Short Text
BW Delta Process: Record Mode
Definition
This attribute describes how a record is updated in the delta process. The various delta processes support different combinations of the seven possible characteristic values. If a DataSource implements a delta process that uses several characteristic values, [...]]]></description>
		<link>http://yangchuang.com/wp22/?p=121</link>
			</item>
</channel>
</rss>
