Hi.

please check your connection properties. You should specifically look for:

IncludeCustomFields

Set it to TRUE.

By default, it will be FALSE.

Hi Erod B,

Thanks for your replay.. i have set the property in connection to true.. however i am receiving above error message

kidlay help me ASAP

Thanks,

Chari

TITLE: Microsoft Visual Studio
------------------------------

Error at Jira_Issues [CData JIRA Source 2]: Unable to process query: "select 
current_date as run_date,
* from Issues where ProjectName = 'BIZAPPSOPS' ".  Exception message: :403] Forbidden error. HTTP protocol error. 403 Forbidden.
Error at Jira_Issues sCData JIRA Source 2 2689]]: bj230L.Vw: :403] Forbidden error. HTTP protocol error. 403 Forbidden.
   at bj230L.hYd.kh(Exception )
   at bj230L.hem.K(String )
   at bj230L.hem.Nx()
   at bj230L.hef.De(pcN )
   at bj230L.pkA.L(BV , pcZ )
   at bj230L.pkA.F(BV , pke )
   at bj230L.pkA.vW(pke , Boolean )
   at bj230L.pke.O(pcj , pwB , jdV , pwB , pwB , String )
   at bj230L.pke.P(BV , pwB , jdV , pwB , pwB )
   at bj230L.pcZ.u(String , BV , pkY , NY )
   at bj230L.pcZ.qp(BV , pkY , NY )
   at bj230L.hhd.m(BV , pkY , NY , heu )
   at bj230L.hej.kz()
   at bj230L.hXO.kz()
   at bj230L.hej.De(pcN )
   at bj230L.pkA.L(BV , pcZ )
   at bj230L.pkA.F(BV , pke )
   at bj230L.pkA.vW(pke , Boolean )
   at bj230L.pcY.H(pcY , pke )
   at bj230L.pcY.lY(pke )
   at bj230L.pOQ.K(pke )
   at bj230L.pOQ.P(pOQ , pke )
   at bj230L.pOQ.lY(pke )
   at bj230L.pOQ.lY(pke )
   at bj230L.pQS.rl(pke )
   at bj230L.tQ.n(pcN , tk )
   at bj230L.tQ.i(pcN , tk , pAl )
   at bj230L.jYt.vM()
   at bj230L.jYl.vM()
   at bj230L.up.d(IDataStatement , SQLQuery , QueryParameterCollection , Int32 , Object , pAl , Int32 , NX )
   at bj230L.jfd.Q(String , String , String )
   at bj230L.jfd.GetColumns(String , String , String , String )
   at bj230L.jfh.GetColumns(String , String , String , String )
   at bj230L.pVl.R(String , String , String , String )
   at bj230L.pVl.GetColumns(String , String , String , String )
   at bj230L.jiO.GetColumns(String , String , String , String )
   at bj230L.NS.GetColumns(String , String , String , String )
   at CData.Sql.ProxyIDataAccess.GetColumns(String catalog, String schema, String table, String column)
   at bj230L.kt.Nk.GetColumns(String , String , String , String )
   at bj230L.jej.GetColumns(String , String , String , String )
   at bj230L.Nj.GetColumns(String , String , String , String )
   at bj230L.kt.O(String , String , String , String , Rm )
   at bj230L.kt.GetColumns(String , String , String )
   at bj230L.jft.X(SqlTable , Boolean )
   at bj230L.jft.R(SqlTable , Boolean )
   at bj230L.jft.m(SqlColumn , Ap )
   at bj230L.Aj.rQ.Visit(U](SqlCollection`1 )
   at CData.Sql.SqlModifier.ModifyColumns(SqlStatement statement)
   at CData.Sql.SqlModifier.ModifyQueryStatement(SqlQueryStatement statement)
   at CData.Sql.SqlModifier.Modify(SqlStatement statement)
   at bj230L.Aj.rQ.Modify(SqlStatement )
   at CData.Sql.SqlModifier.Modify(SqlParser query)
   at bj230L.Aj.g(SqlParser , AB )
   at bj230L.jXf.ce()
   at bj230L.AB.cq()
   at bj230L.jXY.cq()
   at bj230L.jXf.cq()
   at bj230L.AB.qW(QueryParameterCollection )
   at bj230L.hfh.g(String , String , Boolean , Boolean , Boolean , Boolean )
   at bj230L.hfg.ReinitializeMetaData()
   at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostReinitializeMetaData(IDTSManagedComponentWrapper100 wrapper)

------------------------------
ADDITIONAL INFORMATION:

a403] Forbidden error. HTTP protocol error. 403 Forbidden. (Microsoft.SqlServer.DTSPipelineWrap)

------------------------------
BUTTONS:

OK
------------------------------
 

Hi,

This error is related to the permissions you have when connecting to your Jira account. Can you set the following properties:

Logfile: “C:\Users\Public\log.txt

Verbosity: 3

Save the settings, then replicate the problem so that you see the same error again. Then you can send me the file which was created at C:\Users\Public\ in a private message.

The log can help me see what authentication settings you have and what API request is being sent to Jira that returns the 403 error. Log will not include any passwords or private tokens.

Please dont post the log here. Probably it will get removed.