Current position:Home > PX Nsq: PQ load info query

PX Nsq: PQ load info query

Advertisement

AWR Top timed events : PX Nsq: PQ load info query & Streams AQ: qmn coordin

-0001-11-30

Hi, We are reviewing an AWR report for couple of days. And the below events are consistently reported as Top timed events. DB CPU time. enq: TM – contention Streams AQ: qmn coordinator waiting for slave to start enq: TX - row lock contention      PX

How to load a Query in the  bne_stored_sql in WEB ADI table.

2015-10-11

Hi folks , I have a unique requirement as follow. I have created an VIEW , which is given in the Download WEB ADI integrator defintion. I am trying to query this view based in few search conditions thoughr a CO code. I am not used any time loading th

Error in adding attachment to the workitem. load:class Query.class not foun

2015-10-11

Hi, We are using WebGui to access the Business Workplace(SBWP transaction) through Portal. For any work item, when i try to import a file from the local PC, i get a screen with the header -"Enter Some FIle attributes". Text displayed in the scre

SQL Dev 2.1:Ability to save and load visual query models?

-0001-11-30

At SQL Dev 2.1, do we now have the ability to save and load visual query models as with TOAD? Or has that functionality been rolled into the for-pay Data Modeler extension? Seemed strange to hide the functionality deep within SQL Worksheet, then not

MSS Report Export to excel - ERROR - load: class query not found

-0001-11-30

Hi All, I am navigating and getting error as follows: Manger Services ->My reports -> Report Selection -> HIS Reports -> General -> Employee Details -> add some people and click start report -> report shows -> click local file ->

Super slow when loading bw query variables on webi

-0001-11-30

Hi there, On the bw query - OLAP universe - webi stack, sometimes it takes super long (up to around 1 hour) to load bw query variables (i.e., to wait for the variables dialog prompt), just after clicking the "execute query" button. What would we

RE: Load of query results

-0001-11-30

Hi Patrice, Currently, there is little difference between the enterprise edition and the standard edition as you pointed out. However, over time, we expect to see some major differences as we add fucntionality that is more suited for enterprise appli

Load of query results

-0001-11-30

Hi, The final JDO specification is likely to support the need for having an automatic load of query results, probably through a property (thus answering a performance optimization need, as it is better to avoid futher access to the resource manager f

Need to know whether an ODS is loaded or Queried

-0001-11-30

What i need to get is the information whether the ODS objects are being used in the system like whether they are loaded or queried and if not then what was the last date when these operations been performed on them.The number os ADSin our system is m

Unable to load a query of type Text [Power BI designer]

2015-10-11

I have spent all day building a PQ query in Power BI Designer that successfully returns data. it takes a while to do it, but it does return data. When I switch to the report tab to try and build some reports I see this: Then after waiting for a few m

Problems with Full loads/Decreased query performance in Prod

2015-10-11

We have a table which serves as a base for a complex view. The table has roughly around 10 Million records and its a daily full load(I know, that delta loads are much better for handling large sets of data, but this information is very dynamic and wi

Using WHERE command in property loader SQL query

2015-10-11

Hello All, Hopefully this will be a fairly straight forward question. I am attempting to use Property Loader to read in test limits from a SQL database. There are many types of models that need to be tested, each having a unique set of limits. I want

Reference date of last data load in query

-0001-11-30

Is it possible to referece the date of the data load in a query via user exit / formula variable or some other way? We have a requirement to display data in a query based on when the data was last loaded. If the data load has not occured this month,

BEx Load Balancing Query

-0001-11-30

Hi, We are at Bi 7.00/AIX/Oracle. How can we load balance the query running via BEx. Most of the time it is going to CI, which is message server and not part of logon group. Our Web Queries are running fine because we have put a Logon Group in SICF f

Technical Content not loading for Query

-0001-11-30

When running the detail query runtime statics there is no data.  I used transaction rsddstat to turn all of them on.  I have run all the jobs for the loads, but still nothing?   Any ideals.   I have looked at Note 934848 - Collective note: (FAQ) BI A

Issue: No Data loaded from Query - MDX, SQL issue

-0001-11-30

Hello, I'm having a problem with a report based on Query with a hierarchy (0GLACCEXT Hierarchie, Data in Cube 0FIGL_V10), first version of query had 3 filters, but I also tried to load the data without filters thinking it coused the problem - didn't

Error while loading bex query

-0001-11-30

Hi Mates, Throught webi if i try to connect to a bex query im getting the attached error message, any idea what to do.. 2 days back im able to connect to bex query frm webi..frm yesterday its not happening regards, mahihi Ray, Bex query is checked ,

Azure Load Balancer - Query for VMs in rotation or removed from rotationq

-0001-11-30

From what I can tell, there is no way to know if any of the VMs configured as part of a Load-Balanced Set has been taken out of rotation. I see a PS script to set the Azure Load Balancer Endpoint - Set-AzureLoadBalancedEndpoint.  But there is no way

Loading SQL query File

-0001-11-30

Hi, I created all of my tables and constraints into a notepad document, and then when I was finished I named it proj4.sql so it could be loaded into oracle and automatically create my tables and constraints all at once. The problem is, I forgot the c

Boot Loader upgrade query

-0001-11-30

Hi All, I've upgraded a 3750 integrated controller and a 4402 to 5.0.148.0 (s/w and bootloader image) but the sh sysinfo ouput still reports the previous bootloader version: Product Version........... 5.0.148.0 RTOS Version..... Linux-2.6.10_mvl401 B