BI Applications: Bind Variables in View Objects

BI Applications: Bind Variables in View Objects: We have a setting in ADF layer using which we can specify how the View Criteria and the WHERE clauses used in the queries fired on the VOs ...

The request filtering module is configured to deny a request that exceeds the request content length

HTTP Error 400 Bad request

Or

  Unable to upload large/bigger files on to web server (IIS)

Include the following setting in your Web.config file.
<system.webServer>
        <security>
            <requestFiltering>
                <requestLimits maxAllowedContentLength="1000000000" />
            </requestFiltering>
        </security>
    </system.webServer>

It allows upto 1000MB file to be uploaded.
The same can be achieved by the following command too.



%windir%\system32\inetsrv\appcmd set config "Default Web Site/<your app>" -section:requestFiltering -requestLimits.maxAllowedContentLength:1000000000

BI Applications: Trees in Peoplesoft Simplified

BI Applications: Trees in Peoplesoft Simplified: Trees in PSFT can be broadly classified into Summer Trees and Winter Trees. I will take the same example of Department for both the cases so...

BI Applications: Collations in SQL Server

BI Applications: Collations in SQL Server: Character Strings are stored in the SQL Server database using certain Bit Patterns.
A collation specifies the bit patterns that represent e...

BI Applications: Collations in SQL Server

BI Applications: Collations in SQL Server: Character Strings are stored in the SQL Server database using certain Bit Patterns.
A collation specifies the bit patterns that represent e...

BI Applications: Resetting the password for SYS User

BI Applications: Resetting the password for SYS User: "Many times we tend to forget the password of the SYS user. In such cases log onto the machine which hosts the DB server and connect as SYSD..."

BI Applications: Overrides in Informatica

BI Applications: Overrides in Informatica: "Few points regarding overrides in INFA - Source Qualifier Override - 1. The number of columns in the SQ query should match with the numbe..."