Oracle Database 10g Release 2 10.2.0.5 22
Download - https://shurll.com/2tiQF8
This document lists the software patches and releases for Oracle Exadata Database Machine. This document includes versions for both the database servers and storage servers of Oracle Exadata Database Machine with database servers running Intel x86-64 processors. For an index and references to the most frequently used My Oracle Support Notes with respect to Oracle Exadata and Oracle Exadata Database Machine environments, refer to the Primary Note for Oracle Exadata Database Machine and Exadata Storage Server .
Viewed 1000+ timesYou Asked Hello Tom!I have a question about joining with collections and cardinality estimation.For tables with index Oracle 10g suggests plan with full table scan with can be slow on large tables.For example (p_var is a variable in a stored procedure):/* test data */create type n_arr as table of number;create table t1(id number primary key, a1 number);insert into t1 select level,level-1 from dual connect by level true); end;/* Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 */explain plan forselect * from t1 where t1.id in (select column_value from table(cast(:p_var as n_arr)) t2);----------------------------------------------------------------------------------------------------- Id Operation Name Rows Bytes Cost (%CPU) Time ----------------------------------------------------------------------------------------------------- 0 SELECT STATEMENT 255 3060 541 (1) 00:00:07 1 NESTED LOOPS 2 NESTED LOOPS 255 3060 541 (1) 00:00:07 3 SORT UNIQUE 8168 16336 29 (0) 00:00:01 4 COLLECTION ITERATOR PICKLER FETCH 8168 16336 29 (0) 00:00:01 * 5 INDEX UNIQUE SCAN SYS_C0014171 1 1 (0) 00:00:01 6 TABLE ACCESS BY INDEX ROWID T1 1 10 2 (0) 00:00:01 ----------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id):--------------------------------------------------- 5 - access(\"T1\".\"ID\"=VALUE(KOKBF$))/* Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 */explain plan forselect * from t1 where t1.id in (select column_value from table(cast(:p_var as n_arr)) t2);------------------------------------------------------------------------------------------- Id Operation Name Rows Bytes Cost (%CPU) Time ------------------------------------------------------------------------------------------- 0 SELECT STATEMENT 1 11 504 (3) 00:00:07 * 1 HASH JOIN RIGHT SEMI 1 11 504 (3) 00:00:07 2 COLLECTION ITERATOR PICKLER FETCH 3 TABLE ACCESS FULL T1 997K 8765K 476 (2) 00:00:06 ------------------------------------------------------------------------------------------- Predicate Information (identified by operation id):--------------------------------------------------- 1 - access(\"T1\".\"ID\"=VALUE(KOKBF$))Now I use cardinality hint to set the cardinality for collections manually, but the number of elements in collection can be variable.I tried to use dynamic sampling but in Oracle 10g it doeesn't work with collections. /* Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 */explain plan forselect * from t1 where t1.id in (select /*+ cardinality(t2 10)*/ column_value from table(cast(:p_var as n_arr)) t2);--------------------------------------------------------------------------------------------------- Id Operation Name Rows Bytes Cost (%CPU) Time --------------------------------------------------------------------------------------------------- 0 SELECT STATEMENT 10 110 35 (3) 00:00:01 1 NESTED LOOPS 10 110 35 (3) 00:00:01 2 SORT UNIQUE 3 COLLECTION ITERATOR PICKLER FETCH 4 TABLE ACCESS BY INDEX ROWID T1 1 9 2 (0) 00:00:01 * 5 INDEX UNIQUE SCAN SYS_C006586 1 1 (0) 00:00:01 --------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id):--------------------------------------------------- 5 - access(\"T1\".\"ID\"=VALUE(KOKBF$))How oracle estimates cardinality for collectionsHow can be optimized joining and filtering with collections in stored procedures and Tom said...The estimate is based on the block size - you have an 8k block so about 8,000. If ou had a 4k block - about 4,000. and so on.The cardinality hint is good for this - and the number does not have to be \"exact\", just representative. If you expect most of the time to be around \"10\" - (anywhere from 1..100 or maybe even more) - just use 10. It does not have to be precise, it just has to be representative.if the number of elements could vary widely and you want a different plan for say \"small\", \"medium\", and \"large\" collections - you can use three queries - each with a different hint (ref cursors in plsql, dynamic sql in other languages) Rating (4 ratings)Is this answer out of date If it is, please let us know via a Comment Comments Comment ClarificationMuhammad Riaz Shahid, August 29, 2012 - 11:17 pm UTC
install Oracle Database 10g Release 2 (10.2.0.5) client odbc 32 only & fixed\\\",\\\"author\\\":{\\\"username\\\":\\\"former.member\\\",\\\"displayName\\\":\\\"Former Member\\\",\\\"groupIcons\\\":[],\\\"suspended\\\":true,\\\"isCurrentUser\\\":false},\\\"parentAuthor\\\":{\\\"username\\\":\\\"former.member\\\",\\\"displayName\\\":\\\"Former Member\\\",\\\"groupIcons\\\":[],\\\"suspended\\\":true,\\\"isCurrentUser\\\":false},\\\"id\\\":8847827,\\\"creationDate\\\":1321300109000,\\\"activeRevisionId\\\":9767419,\\\"lastActivity\\\":1321300109000,\\\"parentId\\\":8826663,\\\"originalParentId\\\":8715410,\\\"likeCount\\\":0,\\\"visibility\\\":\\\"full\\\",\\\"depth\\\":0,\\\"attachments\\\":[],\\\"canVoteUpOrCancel\\\":false,\\\"relations\\\":{\\\"canReport\\\":false,\\\"visibility\\\":\\\"full\\\",\\\"canEdit\\\":false,\\\"canUseDelete\\\":false,\\\"isLiked\\\":false,\\\"type\\\":\\\"comment\\\",\\\"canVoteUpOrCancel\\\":false,\\\"canConvertToAnswer\\\":false,\\\"canBeModerated\\\":false,\\\"canViewRevisions\\\":false,\\\"showInReply\\\":false,\\\"reported\\\":false,\\\"canCancelReport\\\":false,\\\"canDelete\\\":false,\\\"canVoteDownOrCancel\\\":false,\\\"canComment\\\":false,\\\"canViewReports\\\":false,\\\"isCurrentUserAuthor\\\":false},\\\"liked\\\":false,\\\"moderatorComment\\\":false}]},\\\"8847828\\\":{\\\"rootParentId\\\":8847828,\\\"commentsCount\\\":2,\\\"comments\\\":[{\\\"body\\\":\\\"Did this work\\\",\\\"author\\\":{\\\"username\\\":\\\"justine.lambe\\\",\\\"displayName\\\":\\\"Justine Lambe\\\",\\\"groupIcons\\\":[],\\\"suspended\\\":false,\\\"isCurrentUser\\\":false},\\\"parentAuthor\\\":{\\\"username\\\":\\\"former.member\\\",\\\"displayName\\\":\\\"Former Member\\\",\\\"groupIcons\\\":[],\\\"suspended\\\":true,\\\"isCurrentUser\\\":false},\\\"id\\\":8889506,\\\"creationDate\\\":1322646987000,\\\"activeRevisionId\\\":9800643,\\\"lastActivity\\\":1322646987000,\\\"parentId\\\":8847828,\\\"originalParentId\\\":8715410,\\\"likeCount\\\":0,\\\"visibility\\\":\\\"full\\\",\\\"depth\\\":0,\\\"attachments\\\":[],\\\"canVoteUpOrCancel\\\":false,\\\"relations\\\":{\\\"canReport\\\":false,\\\"visibility\\\":\\\"full\\\",\\\"canEdit\\\":false,\\\"canUseDelete\\\":false,\\\"isLiked\\\":false,\\\"type\\\":\\\"comment\\\",\\\"canVoteUpOrCancel\\\":false,\\\"canConvertToAnswer\\\":false,\\\"canBeModerated\\\":false,\\\"canViewRevisions\\\":false,\\\"showInReply\\\":false,\\\"reported\\\":false,\\\"canCancelReport\\\":false,\\\"canDelete\\\":false,\\\"canVoteDownOrCancel\\\":false,\\\"canComment\\\":false,\\\"canViewReports\\\":false,\\\"isCurrentUserAuthor\\\":false},\\\"liked\\\":false,\\\"moderatorComment\\\":false}]},\\\"9199739\\\":{\\\"rootParentId\\\":9199739,\\\"commentsCount\\\":4,\\\"comments\\\":[{\\\"body\\\":\\\"Update the Data Source location from server to server \\\",\\\"author\\\":{\\\"username\\\":\\\"former.member\\\",\\\"displayName\\\":\\\"Former Member\\\",\\\"groupIcons\\\":[],\\\"suspended\\\":true,\\\"isCurrentUser\\\":false},\\\"parentAuthor\\\":{\\\"username\\\":\\\"former.member\\\",\\\"displayName\\\":\\\"Former Member\\\",\\\"groupIcons\\\":[],\\\"suspended\\\":true,\\\"isCurrentUser\\\":false},\\\"id\\\":12405869,\\\"creationDate\\\":1464092364000,\\\"activeRevisionId\\\":12702896,\\\"lastActivity\\\":1464092367000,\\\"parentId\\\":10374129,\\\"originalParentId\\\":8715410,\\\"likeCount\\\":0,\\\"visibility\\\":\\\"full\\\",\\\"depth\\\":0,\\\"attachments\\\":[],\\\"canVoteUpOrCancel\\\":false,\\\"relations\\\":{\\\"canReport\\\":false,\\\"visibility\\\":\\\"full\\\",\\\"canEdit\\\":false,\\\"canUseDelete\\\":false,\\\"isLiked\\\":false,\\\"type\\\":\\\"comment\\\",\\\"canVoteUpOrCancel\\\":false,\\\"canConvertToAnswer\\\":false,\\\"canBeModerated\\\":false,\\\"canViewRevisions\\\":false,\\\"showInReply\\\":false,\\\"reported\\\":false,\\\"canCancelReport\\\":false,\\\"canDelete\\\":false,\\\"canVoteDownOrCancel\\\":false,\\\"canComment\\\":false,\\\"canViewReports\\\":false,\\\"isCurrentUserAuthor\\\":false},\\\"liked\\\":false,\\\"moderatorComment\\\":false}]},\\\"8716003\\\":{\\\"rootParentId\\\":8716003,\\\"commentsCount\\\":2,\\\"comments\\\":[{\\\"body\\\":\\\"Hi Steven, Were you able to resolve this issue If so, what steps did you take to get there. I'm having the same problem with our installation.\\\\n\\\\nRegards,\\\\n\\\\n-Tim\\\",\\\"author\\\":{\\\"username\\\":\\\"former.member\\\",\\\"displayName\\\":\\\"Former Member\\\",\\\"groupIcons\\\":[],\\\"suspended\\\":true,\\\"isCurrentUser\\\":false},\\\"parentAuthor\\\":{\\\"username\\\":\\\"former.member\\\",\\\"displayName\\\":\\\"Former Member\\\",\\\"groupIcons\\\":[],\\\"suspended\\\":true,\\\"isCurrentUser\\\":false},\\\"id\\\":8803232,\\\"creationDate\\\":1319653745000,\\\"activeRevisionId\\\":9731956,\\\"lastActivity\\\":1319653745000,\\\"parentId\\\":8718063,\\\"originalParentId\\\":8715410,\\\"likeCount\\\":0,\\\"visibility\\\":\\\"full\\\",\\\"depth\\\":0,\\\"attachments\\\":[],\\\"canVoteUpOrCancel\\\":false,\\\"relations\\\":{\\\"canReport\\\":false,\\\"visibility\\\":\\\"full\\\",\\\"canEdit\\\":false,\\\"canUseDelete\\\":false,\\\"isLiked\\\":false,\\\"type\\\":\\\"comment\\\",\\\"canVoteUpOrCancel\\\":false,\\\"canConvertToAnswer\\\":false,\\\"canBeModerated\\\":false,\\\"canViewRevisions\\\":false,\\\"showInReply\\\":false,\\\"reported\\\":false,\\\"canCancelReport\\\":false,\\\"canDelete\\\":false,\\\"canVoteDownOrCancel\\\":false,\\\"canComment\\\":false,\\\"canViewReports\\\":false,\\\"isCurrentUserAuthor\\\":false},\\\"liked\\\":false,\\\"moderatorComment\\\":false}]}}\"); const simplifiedQuestionView = JSON.parse(\"true\"); (function() { window.pageContext = mergeDeep(pageContext, { question: { id: 8715410, plug: \"connection-error-when-viewing-crystal-report-on-sa\", votes: 2, questionTitle: \"connection error when viewing crystal report on SAP BO BI4.0\", isClosed: false, isLocked: false, isRedirected: false, redirectedFromTitle: \"\", redirectedFromId: \"\", closedStatusData: JSON.parse(\"{}\"), userVoted: false, relations: JSON.parse(\"{\\\"canClose\\\":false,\\\"canUnredirect\\\":false,\\\"canReport\\\":false,\\\"visibility\\\":\\\"full\\\",\\\"canEdit\\\":false,\\\"canUseDelete\\\":false,\\\"canReopen\\\":false,\\\"type\\\":\\\"question\\\",\\\"canVoteUpOrCancel\\\":false,\\\"canViewRevisions\\\":true,\\\"score\\\":2,\\\"canUnlock\\\":false,\\\"reported\\\":false,\\\"canVoteDownOrCancel\\\":false,\\\"canLock\\\":false,\\\"canCancelReport\\\":false,\\\"canComment\\\":true,\\\"isCurrentUserAuthor\\\":false,\\\"canViewReports\\\":false}\"), isQuestionAccepted: false }, childToViewInfo: { id: \"\" }, comments: JSON.parse(\"{\\\"8826663\\\":{\\\"rootParentId\\\":8826663,\\\"commentsCount\\\":1,\\\"comments\\\":[{\\\"body\\\":\\\"install Oracle Database 10g Release 2 (10.2.0.5) client odbc 32 only & fixed\\\",\\\"author\\\":{\\\"username\\\":\\\"former.member\\\",\\\"displayName\\\":\\\"Former Member\\\",\\\"groupIcons\\\":[],\\\"suspended\\\":true,\\\"isCurrentUser\\\":false},\\\"parentAuthor\\\":{\\\"username\\\":\\\"former.member\\\",\\\"displayName\\\":\\\"Former Member\\\",\\\"groupIcons\\\":[],\\\"suspended\\\":true,\\\"isCurrentUser\\\":false},\\\"id\\\":8847827,\\\"creationDate\\\":1321300109000,\\\"activeRevisionId\\\":9767419,\\\"lastActivity\\\":1321300109000,\\\"parentId\\\":8826663,\\\"originalParentId\\\":8715410,\\\"likeCount\\\":0,\\\"visibility\\\":\\\"full\\\",\\\"depth\\\":0,\\\"attachments\\\":[],\\\"canVoteUpOrCancel\\\":false,\\\"relations\\\":{\\\"canReport\\\":false,\\\"visibility\\\":\\\"full\\\",\\\"canEdit\\\":false,\\\"canUseDelete\\\":false,\\\"isLiked\\\":false,\\\"type\\\":\\\"comment\\\",\\\"canVoteUpOrCancel\\\":false,\\\"canConvertToAnswer\\\":false,\\\"canBeModerated\\\":false,\\\"canViewRevisions\\\":false,\\\"showInReply\\\":false,\\\"reported\\\":false,\\\"canCancelReport\\\":false,\\\"canDelete\\\":false,\\\"canVoteDownOrCancel\\\":false,\\\"canComment\\\":false,\\\"canViewReports\\\":false,\\\"isCurrentUserAuthor\\\":false},\\\"liked\\\":false,\\\"moderatorComment\\\":false}]},\\\"8847828\\\":{\\\"rootParentId\\\":8847828,\\\"commentsCount\\\":2,\\\"comments\\\":[{\\\"body\\\":\\\"Did this work\\\",\\\"author\\\":{\\\"username\\\":\\\"justine.lambe\\\",\\\"displayName\\\":\\\"Justine Lambe\\\",\\\"groupIcons\\\":[],\\\"suspended\\\":false,\\\"isCurrentUser\\\":false},\\\"parentAuthor\\\":{\\\"username\\\":\\\"former.member\\\",\\\"displayName\\\":\\\"Former Member\\\",\\\"groupIcons\\\":[],\\\"suspended\\\":true,\\\"isCurrentUser\\\":false},\\\"id\\\":8889506,\\\"creationDate\\\":1322646987000,\\\"activeRevisionId\\\":9800643,\\\"lastActivity\\\":1322646987000,\\\"parentId\\\":8847828,\\\"originalParentId\\\":8715410,\\\"likeCount\\\":0,\\\"visibility\\\":\\\"full\\\",\\\"depth\\\":0,\\\"attachments\\\":[],\\\"canVoteUpOrCancel\\\":false,\\\"relations\\\":{\\\"canReport\\\":false,\\\"visibility\\\":\\\"full\\\",\\\"canEdit\\\":false,\\\"canUseDelete\\\":false,\\\"isLiked\\\":false,\\\"type\\\":\\\"comment\\\",\\\"canVoteUpOrCancel\\\":false,\\\"canConvertToAnswer\\\":false,\\\"canBeModerated\\\":false,\\\"canViewRevisions\\\":false,\\\"showInReply\\\":false,\\\"reported\\\":false,\\\"canCancelReport\\\":false,\\\"canDelete\\\":false,\\\"canVoteDownOrCancel\\\":false,\\\"canComment\\\":false,\\\"canViewReports\\\":false,\\\"isCurrentUserAuthor\\\":false},\\\"liked\\\":false,\\\"moderatorComment\\\":false}]},\\\"9199739\\\":{\\\"rootParentId\\\":9199739,\\\"commentsCount\\\":4,\\\"comments\\\":[{\\\"body\\\":\\\"Update the Data Source location from server to server \\\",\\\"author\\\":{\\\"username\\\":\\\"former.member\\\",\\\"displayName\\\":\\\"Former Member\\\",\\\"groupIcons\\\":[],\\\"suspended\\\":true,\\\"isCurrentUser\\\":false},\\\"parentAuthor\\\":{\\\"username\\\":\\\"former.member\\\",\\\"displayName\\\":\\\"Former Member\\\",\\\"groupIcons\\\":[],\\\"suspended\\\":true,\\\"isCurrentUser\\\":false},\\\"id\\\":12405869,\\\"creationDate\\\":1464092364000,\\\"activeRevisionId\\\":12702896,\\\"lastActivity\\\":1464092367000,\\\"parentId\\\":10374129,\\\"originalParentId\\\":8715410,\\\"likeCount\\\":0,\\\"visibility\\\":\\\"full\\\",\\\"depth\\\":0,\\\"attachments\\\":[],\\\"canVoteUpOrCancel\\\":false,\\\"relations\\\":{\\\"canReport\\\":false,\\\"visibility\\\":\\\"full\\\",\\\"canEdit\\\":false,\\\"canUseDelete\\\":false,\\\"isLiked\\\":false,\\\"type\\\":\\\"comment\\\",\\\"canVoteUpOrCancel\\\":false,\\\"canConvertToAnswer\\\":false,\\\"canBeModerated\\\":false,\\\"canViewRevisions\\\":false,\\\"showInReply\\\":false,\\\"reported\\\":false,\\\"canCancelReport\\\":false,\\\"canDelete\\\":false,\\\"canVoteDownOrCancel\\\":false,\\\"canComment\\\":false,\\\"canViewReports\\\":false,\\\"isCurrentUserAuthor\\\":false},\\\"liked\\\":false,\\\"moderatorComment\\\":false}]},\\\"8716003\\\":{\\\"rootParentId\\\":8716003,\\\"commentsCount\\\":2,\\\"comments\\\":[{\\\"body\\\":\\\"Hi Steven, Were you able to resolve this issue If so, what steps did you take to get there. I'm having the same problem with our installation.\\\\n\\\\nRegards,\\\\n\\\\n-Tim\\\",\\\"author\\\":{\\\"username\\\":\\\"former.member\\\",\\\"displayName\\\":\\\"Former Member\\\",\\\"groupIcons\\\":[],\\\"suspended\\\":true,\\\"isCurrentUser\\\":false},\\\"parentAuthor\\\":{\\\"username\\\":\\\"former.member\\\",\\\"displayName\\\":\\\"Former Member\\\",\\\"groupIcons\\\":[],\\\"suspended\\\":true,\\\"isCurrentUser\\\":false},\\\"id\\\":8803232,\\\"creationDate\\\":1319653745000,\\\"activeRevisionId\\\":9731956,\\\"lastActivity\\\":1319653745000,\\\"parentId\\\":8718063,\\\"originalParentId\\\":8715410,\\\"likeCount\\\":0,\\\"visibility\\\":\\\"full\\\",\\\"depth\\\":0,\\\"attachments\\\":[],\\\"canVoteUpOrCancel\\\":false,\\\"relations\\\":{\\\"canReport\\\":false,\\\"visibility\\\":\\\"full\\\",\\\"canEdit\\\":false,\\\"canUseDelete\\\":false,\\\"isLiked\\\":false,\\\"type\\\":\\\"comment\\\",\\\"canVoteUpOrCancel\\\":false,\\\"canConvertToAnswer\\\":false,\\\"canBeModerated\\\":false,\\\"canViewRevisions\\\":false,\\\"showInReply\\\":false,\\\"reported\\\":false,\\\"canCancelReport\\\":false,\\\"canDelete\\\":false,\\\"canVoteDownOrCancel\\\":false,\\\"canComment\\\":false,\\\"canViewReports\\\":false,\\\"isCurrentUserAuthor\\\":false},\\\"liked\\\":false,\\\"moderatorComment\\\":false}]}}\"), answerPager: { answersCount: 6, page: 1, pageSize: 10, pageCount: 1, sort: \"votes\" }, answers: JSON.parse(\"[{\\\"body\\\":\\\"install Oracle Database 10g Release 2 (10.2.0.5) client odbc 32 only & fixed\\\",\\\"author\\\":{\\\"username\\\":\\\"former.member\\\",\\\"displayName\\\":\\\"Former Member\\\",\\\"groupIcons\\\":[],\\\"suspended\\\":true,\\\"isCurrentUser\\\":false},\\\"id\\\":8847828,\\\"posted\\\":1321300133000,\\\"votes\\\":1,\\\"isAccepted\\\":false,\\\"isLocked\\\":false,\\\"userVoted\\\":\\\"\\\",\\\"relations\\\":{\\\"score\\\":1,\\\"canCancelAccept\\\":false,\\\"canUnlock\\\":false,\\\"canUseDelete\\\":false,\\\"canVoteDownOrCancel\\\":false,\\\"canLock\\\":false,\\\"canAccept\\\":false,\\\"type\\\":\\\"answer\\\",\\\"canVoteUpOrCancel\\\":false,\\\"isCurrentUserAuthor\\\":false},\\\"attachments\\\":[]},{\\\"body\\\":\\\"You have to make sure that you have configured 32bit ODBC driver on client side and server side with 32 bit data source administration. You can find the 32 bit data source administration under folder C:\\\\\\\\Windows\\\\\\\\SysWOW64\\\\\\\\odbcad32.exe. ( the data source name on server side and client side should be the same). The one under start-->adminstration tool is 64bit data source administration. I have encounterd the problem before.\\\",\\\"author\\\":{\\\"username\\\":\\\"former.employee\\\",\\\"displayName\\\":\\\"Former Member\\\",\\\"groupIcons\\\":[{\\\"name\\\":\\\"employee\\\",\\\"title\\\":\\\"This user is an SAP Employee\\\",\\\"priority\\\":21}],\\\"suspended\\\":true,\\\"isCurrentUser\\\":false},\\\"id\\\":9199739,\\\"posted\\\":1333347671000,\\\"votes\\\":1,\\\"isAccepted\\\":false,\\\"isLocked\\\":false,\\\"userVoted\\\":\\\"\\\",\\\"relations\\\":{\\\"score\\\":1,\\\"canCancelAccept\\\":false,\\\"canUnlock\\\":false,\\\"canUseDelete\\\":false,\\\"canVoteDownOrCancel\\\":false,\\\"canLock\\\":false,\\\"canAccept\\\":false,\\\"type\\\":\\\"answer\\\",\\\"canVoteUpOrCancel\\\":false,\\\"isCurrentUserAuthor\\\":false},\\\"attachments\\\":[]},{\\\"body\\\":\\\"Hi Steven,\\\\n\\\\nImproper database credentials for the report leads to this error. Kindly refer:\\\\n\\\\n \\\\n\\\\nRegards,\\\\n\\\\nNakul\\\",\\\"author\\\":{\\\"username\\\":\\\"former.member\\\",\\\"displayName\\\":\\\"Former Member\\\",\\\"groupIcons\\\":[],\\\"suspended\\\":true,\\\"isCurrentUser\\\":false},\\\"id\\\":8716003,\\\"posted\\\":1316755145000,\\\"votes\\\":0,\\\"isAccepted\\\":false,\\\"isLocked\\\":false,\\\"userVoted\\\":\\\"\\\",\\\"relations\\\":{\\\"canCancelAccept\\\":false,\\\"canUnlock\\\":false,\\\"canUseDelete\\\":false,\\\"canVoteDownOrCancel\\\":false,\\\"canLock\\\":false,\\\"canAccept\\\":false,\\\"type\\\":\\\"answer\\\",\\\"canVoteUpOrCancel\\\":false,\\\"isCurrentUserAuthor\\\":false},\\\"attachments\\\":[]},{\\\"body\\\":\\\"We have the same issue.\\\",\\\"author\\\":{\\\"username\\\":\\\"former.member\\\",\\\"displayName\\\":\\\"Former Member\\\",\\\"groupIcons\\\":[],\\\"suspended\\\":true,\\\"isCurrentUser\\\":false},\\\"id\\\":8808433,\\\"posted\\\":1319820164000,\\\"votes\\\":0,\\\"isAccepted\\\":false,\\\"isLocked\\\":false,\\\"userVoted\\\":\\\"\\\",\\\"relations\\\":{\\\"canCancelAccept\\\":false,\\\"canUnlock\\\":false,\\\"canUseDelete\\\":false,\\\"canVoteDownOrCancel\\\":false,\\\"canLock\\\":false,\\\"canAccept\\\":false,\\\"type\\\":\\\"answer\\\",\\\"canVoteUpOrCancel\\\":false,\\\"isCurrentUserAuthor\\\":false},\\\"attachments\\\":[]},{\\\"body\\\":\\\"Hello Everyone,\\\\n\\\\nWe are also facing the same issue. The crystal Reports migrated from BOBJ Dev XI 3.1 version to SBOP 4.0 version work fine. Where as the crystal reports migrated from BOBJ QA XI 3.1 version tp SBOP 4.0 version gives me \"CRWEB00000119\" error. \\\\n\\\\nI checked the Database Configuration as given in SAP Note 1558691, I checked the config of QA system against Dev system where the CR's are working and everything is same, except for Dev CR is pointing to BW Dev system and QA CR is pointing to BW QA system.\\\\n\\\\nSo I am not sure why I am getting this connectivity error (\"The viewer could not process an event. The database logon information for this report is either incomplete or incorrect. [] \\\\n---- Error code:0 [CRWEB00000119]\"). \\\\n\\\\nOne more interesting point is, it gets the variables screen and allows us to select from the list of values so it is able to talk to BW system to get the list of values so I am not sure why it is throwing connectivity error while executing the report.\\\\n\\\\nIf anyone was able to solve this problem, please let me know.\\\\n\\\\nAny comments will be greatly appreciated.\\\\n\\\\nThanks & Regards,\\\\n\\\\nSRV\\\",\\\"author\\\":{\\\"username\\\":\\\"former.member\\\",\\\"displayName\\\":\\\"Former Member\\\",\\\"groupIcons\\\":[],\\\"suspended\\\":true,\\\"isCurrentUser\\\":false},\\\"id\\\":8826663,\\\"posted\\\":1320632541000,\\\"votes\\\":0,\\\"isAccepted\\\":false,\\\"isLocked\\\":false,\\\"userVoted\\\":\\\"\\\",\\\"relations\\\":{\\\"canCancelAccept\\\":false,\\\"canUnlock\\\":false,\\\"canUseDelete\\\":false,\\\"canVoteDownOrCancel\\\":false,\\\"canLock\\\":false,\\\"canAccept\\\":false,\\\"type\\\":\\\"answer\\\",\\\"canVoteUpOrCancel\\\":false,\\\"isCurrentUserAuthor\\\":false},\\\"attachments\\\":[]},{\\\"body\\\":\\\"We are experiencing the same issue when going from 3.1 to 4.0. Was it simply a matter of installing only the 32-bit ODBC driver\\\\n\\\\nThanks,\\\\nDave\\\",\\\"author\\\":{\\\"username\\\":\\\"former.member\\\",\\\"displayName\\\":\\\"Former Member\\\",\\\"groupIcons\\\":[],\\\"suspended\\\":true,\\\"isCurrentUser\\\":false},\\\"id\\\":9111988,\\\"posted\\\":1329947385000,\\\"votes\\\":0,\\\"isAccepted\\\":false,\\\"isLocked\\\":false,\\\"userVoted\\\":\\\"\\\",\\\"relations\\\":{\\\"canCancelAccept\\\":false,\\\"canUnlock\\\":false,\\\"canUseDelete\\\":false,\\\"canVoteDownOrCancel\\\":false,\\\"canLock\\\":false,\\\"canAccept\\\":false,\\\"type\\\":\\\"answer\\\",\\\"canVoteUpOrCancel\\\":false,\\\"isCurrentUserAuthor\\\":false},\\\"attachments\\\":[]}]\"), answerForm: { formAction: \"/answers/8715410/post.json\", textareaName: \"body\", textareaErrors: \"\", isAttachmentsEnabled: true, answerEditorialGuideline: { title: \"Before answering\", content: \"You should only submit an answer when you are proposing a solution to the poster\\'s problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that your answer complies with our Rules of Engagement.\", links: [ {title: \"Rules of Engagement\", href: \" -of-engagement.html\"}, ] }, answerMinBodyLength: '10', answerMaxBodyLength: '20000' }, currentUser: { sapInternalId: '', permissions: { canVoteUpOrCancel: false, canVoteDownOrCancel: false, canModerate: false, }, isVotedUp: false, isVotedDown: false }, alerts: { alertModeratorMinLength : \"It should be given a proper explanation about why the content is inappropriate.\", alertModeratorMinLengthValue : \"10\", alreadyReportedMessage : \"You already have an active moderator alert for this content.\" }, url: { profileApiBaseUrl: ' -api.services.sap.com', followUnfollowQuestion: '/sap/nodeSubscription.json', isFollowingQuestion: '/sap/isFollowingNode.json', vote: { voteUp: '/commands/0/voteup.json', voteDown: '/commands/0/votedown.json', cancelVote: '/commands/0/cancelvote.json' }, rss: { answers: '/feed/8715410/answers.rss', answersAndComments: '/feed/8715410/comments-and-answers.rss' } }, authorizeUploadContext: { type: 'answer' }, atMention: { userSearchServiceUrl: ' ', currentUserName: '', useNewUSSCORS: true, atMentionDelayMs: 100, showMentionInRedactor: true }, attachmentSettings: { commentMaxAttachments: '2', answerMaxAttachments: '10', commentMaxAttachmentSizeBytes: '1048576', answerMaxAttachmentSizeBytes: '1048576', commentAttachmentsSizeBytesTotal: '2097152', answerAttachmentsSizeBytesTotal: '10485760' }, editor: { editorClipboardUploadEnabled: true } }) })(); Home Community Ask a Question Write a Blog Post Login / Sign-up Search Questions and Answers 2 Former Member Sep 22, 2011 at 08:30 PM connection error when viewing crystal report on SAP BO BI4.0 1024 Views Follow RSS Feed We have issue when trying to view crystal report on BO BI4.0 server. 153554b96e
https://www.aunt-flo.org/forum/period-poverty/evermotion-archshaders-vol-3-vrayl
https://www.cprclasstexas.com/forum/medical-forum/juniper-network-connect-for-mac