Translate

Friday, 31 August 2012

Shahed

BI publisher too many tables query builder

BI Publisher Query Builder

Too Many Tables in query builder for schema

Workaround This is only a workaround and deploying a new version may be everything else!

1. J2EE in the Directory Server (the server application is running BI Publisher),

Locate the file "qb.jsp" (eg D: \ OracleBI \ oc4j_bi \ j2ee \ home \ applications \ xmlpserver \ xmlpserver \ qb \ qb.jsp )



2. File backup

3. file to open it and find it ERROR_TOO_MANY_OBJECTS

4. The present value (in my case 100) - change the example to 300

11.1.1.6.8 try changing the 99 to a higher value

for (int j=0; j<resultTbls.length; j++)
                                {
                                  if (j>99)
                                  {
                                         out.print("ERROR_TOO_MANY_OBJECTS");
                                         return;
                                  }
                                  ts.add(resultTbls[j]);
                                }

                                //while (r.next()) {
                                // if (i++ > 100) {
                                // out.print("ERROR_TOO_MANY_OBJECTS");
                                // return;
                                // }
                                // ts.add(r.getString(3));

5. Save the file

6. Restore Query Builder page - the result

Blog Archive

About Authors

Shahed Munir

Krishna Udathu

Shahed and Krishna are Oracle / Big Data Experts