Friday, October 29, 2010

The remote server returned an error: (401) Unauthorized. twitter api

 

Server Error in '/twitweb' Application.

The remote server returned an error: (401) Unauthorized.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Net.WebException: The remote server returned an error: (401) Unauthorized.

Source Error:

Line 271:            finally Line 272:            { Line 273:                webRequest.GetResponse().GetResponseStream().Close(); Line 274:                responseReader.Close(); Line 275:                responseReader = null;

Source File: c:\Inetpub\wwwroot\twitweb\App_Code\oAuthTwitter.cs    Line: 273

Stack Trace:

[WebException: The remote server returned an error: (401) Unauthorized.]    System.Net.HttpWebRequest.GetResponse() +1126    oAuthExample.oAuthTwitter.WebResponseGet(HttpWebRequest webRequest) in c:\Inetpub\wwwroot\twitweb\App_Code\oAuthTwitter.cs:273    oAuthExample.oAuthTwitter.WebRequest(Method method, String url, String postData) in c:\Inetpub\wwwroot\twitweb\App_Code\oAuthTwitter.cs:244    oAuthExample.oAuthTwitter.oAuthWebRequest(Method method, String url, String postData) in c:\Inetpub\wwwroot\twitweb\App_Code\oAuthTwitter.cs:199    oAuthExample.oAuthTwitter.AccessTokenGet(String authToken, String oauthVerifier) in c:\Inetpub\wwwroot\twitweb\App_Code\oAuthTwitter.cs:103    Default6.Page_Load(Object sender, EventArgs e) in c:\Inetpub\wwwroot\twitweb\Default6.aspx.cs:32    System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +25    System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +42    System.Web.UI.Control.OnLoad(EventArgs e) +132    System.Web.UI.Control.LoadRecursive() +66    System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2428 


Version Information: Microsoft .NET Framework Version:2.0.50727.3615; ASP.NET Version:2.0.50727.3614
 
if you are using same message again 2 times you will get this error.change your message and then try.

The remote server returned an error: (403) Forbidden. Twitter api error

 Server Error in '/twitweb' Application.

The remote server returned an error: (403) Forbidden.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Net.WebException: The remote server returned an error: (403) Forbidden.

Source Error:

Line 271:            finally Line 272:            { Line 273:                webRequest.GetResponse().GetResponseStream().Close(); Line 274:                responseReader.Close(); Line 275:                responseReader = null;

Source File: c:\Inetpub\wwwroot\twitweb\App_Code\oAuthTwitter.cs    Line: 273

Stack Trace:

[WebException: The remote server returned an error: (403) Forbidden.]    System.Net.HttpWebRequest.GetResponse() +1126    oAuthExample.oAuthTwitter.WebResponseGet(HttpWebRequest webRequest) in c:\Inetpub\wwwroot\twitweb\App_Code\oAuthTwitter.cs:273    oAuthExample.oAuthTwitter.WebRequest(Method method, String url, String postData) in c:\Inetpub\wwwroot\twitweb\App_Code\oAuthTwitter.cs:244    oAuthExample.oAuthTwitter.oAuthWebRequest(Method method, String url, String postData) in c:\Inetpub\wwwroot\twitweb\App_Code\oAuthTwitter.cs:199    Default6.Page_Load(Object sender, EventArgs e) in c:\Inetpub\wwwroot\twitweb\Default6.aspx.cs:42    System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +25    System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +42    System.Web.UI.Control.OnLoad(EventArgs e) +132    System.Web.UI.Control.LoadRecursive() +66    System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2428 
 
 
 
if you are using .net sample code getting this error while trying to do status update use following code in default.aspx:
 
 

using

System;

using

System.Data;

using

System.Configuration;

using

System.Collections;

using

System.Web;

using

System.Web.Security;

using

System.Web.UI;

using

System.Web.UI.WebControls;

using

System.Web.UI.WebControls.WebParts;

using

System.Web.UI.HtmlControls;

using

oAuthExample;

public

partial class _Default : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

string url = "";

string xml = "";

oAuthTwitter oAuth = new oAuthTwitter();

if (Request["oauth_token"] == null)

{

//Redirect the user to Twitter for authorization.

//Using oauth_callback for local testing.

oAuth.CallBackUrl =

"http://localhost/twitweb/default6.aspx";

Response.Redirect(oAuth.AuthorizationLinkGet());

}

else

{

//Get the access token and secret.

oAuth.AccessTokenGet(Request[

"oauth_token"], Request["oauth_verifier"]);

if (oAuth.TokenSecret.Length > 0)

{

//We now have the credentials, so make a call to the Twitter API.

// url = "http://twitter.com/account/verify_credentials.xml";

//xml = oAuth.oAuthWebRequest(oAuthTwitter.Method.GET, url, String.Empty);

//apiResponse.InnerHtml = Server.HtmlEncode(xml);

//POST Test

url =

"http://twitter.com/statuses/update.xml";

xml = oAuth.oAuthWebRequest(

oAuthTwitter.Method.POST, url, "status=" + oAuth.UrlEncode("test 123 Hello Testing the .NET oAuth API 3"));

apiResponse.InnerHtml = Server.HtmlEncode(xml);

}

}

}

}


 

Tuesday, October 26, 2010

Twitter retweet/tweet c# code behind sample

Label6.Text =

"<a href='http://twitter.com/share' class='twitter-share-button' data-url='http://www.wwwwwwww.com/fblike/default2.aspx?id='"+ Request.RawUrl.ToString() + "'data-text='"+ Page.Title.ToString() +"' data-count='none' data-via='rajeevkum'>Tweet</a><script type='text/javascript' src='http://platform.twitter.com/widgets.js'></script>";

Twitter Tweet, Facebook Like code C# gridview

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" RowStyle-Font-Bold="true"
RowStyle-Font-Size="13" RowStyle-Font-Names="Arial"
DataKeyNames="linkid" DataSourceID="AccessDataSource1" width="90%">
<columns>
<asp:templatefield headertext="Popular Likes">
<itemtemplate>
<li><a href="'default2.aspx?id="<%#">'><%# Eval("linkdesc") %> </a>
<br />
<iframe src="http://www.facebook.com/plugins/like.php?href="http://www.vvvvvv.com/fblike/default2.aspx?id="<%#"> &amp;layout=button_count&amp;show_faces=false&amp;action=like&amp;font=arial&amp;colorscheme=light&amp;height=21&amp;width=100&amp;locale=en_US' scrolling='no' frameborder='0' allowTransparency='true' style='margin-left:15px; height:21px; width:95px;'></iframe>'
  
<a href="http://twitter.com/share" class="twitter-share-button" url="http://www.bigtechie.com/fblike/default2.aspx?id=<%# Eval(">" data-text='<%# Eval("linkdesc") %>' data-count="none" data-via="rajeevkum">Tweet</a><script type="text/javascript" src="http://platform.twitter.com/widgets.js"></script>


</li>
<br />
</itemtemplate>
</asp:TemplateField>
</columns>
</asp:GridView>
<asp:AccessDataSource ID="AccessDataSource1" runat="server"
DataFile="e:\fblike.mdb"
SelectCommand="SELECT [linkid], [linkdesc],[linkfblk] FROM [linkdesc] where linkid<>3 order by linkid desc">
</asp:AccessDataSource>

Monday, October 25, 2010

Displaying Rectangle area google map address in webpage in html

Displaying Rectangle area google map address in webpage in html.
 
 
<map name="map" id="map">
    <area shape="rect"  coords="70,445,355,650"  target="_blank"
    href="http://maps.google.com/maps?q=Your Address"
    alt="Click Here For Map and Direction" title="Click Here For Map and Directions"/>
</map>

 


Friday, October 22, 2010

Tab sequence JD Edwards Application

Click on Layout after that on "Add Tab Sequence"
 
 

Thursday, October 21, 2010

Error: Intercompany Out of Balance -JD Edwards EnterpriseOne, V-Batch

If you are not able to post V- Batch (voucher) getting following error, I fix these errors following way:-
 
 
Informational: Call From     : rKumar
Contact       :
Phone Number  :
Tickler Date  : 10/21/2010
Subject       : Error: Intercompany Out of Balance
Cause . . . . . Your intercompany settlements are out of balance for 
 this batch.  The intercompany settlement method being used 
 is either '1', '2', or '3'.  When using these methods of
 intercompany settlements, transactions between companies are
 allowed.  The post will create intercompany settlements for out
 of balance companies, but each document within the batch, as
 well as the batch as a whole, must be in balance (debits equal
 credits).

Resolution. . .  Please clean up any out of balance entries and then Repost this batch.

 

First calculate total by using following queries and store in temp tables

select gldoc,sum(glaa)glaa into jde_rk.dbo.temp693431 from proddta.f0911 where glicu=694337 group by gldoc
select rpdoc,sum(rpag)rpag into jde_rk.dbo.tempRP693431 from proddta.f0411 where rpicu=694337 group by rpdoc


After that find exact document number which is causing out of balance
select * from jde_rk.dbo.temp693431
left outer join jde_rk.dbo.tempRP693431 on gldoc=rpdoc
where glaa<>rpag

Talk to finance department before update F0911 Data, you have to put difference and change F0911 record.

select glaa,* from proddta.f0911 where gldoc=506594.0 and glicu=694337
update proddta.f0911 set glaa=23322 where gldoc=506594.0 and glicu=694337


 

Error: Intercompany Out of Balance- JD Edwards EnterpriseOne

If you are not able to post V- Batch (voucher) getting following error, I fix these errors following way:-
 
Informational: Call From     : rKumar
Contact       :
Phone Number  :
Tickler Date  : 10/21/2010
Subject       : Error: Intercompany Out of Balance
Cause . . . . . Your intercompany settlements are out of balance for 
 this batch.  The intercompany settlement method being used 
 is either '1', '2', or '3'.  When using these methods of
 intercompany settlements, transactions between companies are
 allowed.  The post will create intercompany settlements for out
 of balance companies, but each document within the batch, as
 well as the batch as a whole, must be in balance (debits equal
 credits).
Resolution. . .  Please clean up any out of balance entries and then Repost this batch.
 
First calculate total by using following queries and store in temp tables
select gldoc,sum(glaa)glaa into jde_rk.dbo.temp693431 from proddta.f0911 where glicu=694337 group by gldoc
select rpdoc,sum(rpag)rpag into jde_rk.dbo.tempRP693431 from proddta.f0411 where rpicu=694337 group by rpdoc

After that find exact document number which is causing out of balance
select * from jde_rk.dbo.temp693431
left outer join jde_rk.dbo.tempRP693431 on gldoc=rpdoc
where glaa<>rpag
Talk to finance department before update F0911 Data
select glaa,* from proddta.f0911 where gldoc=506594.0 and glicu=694337
update proddta.f0911 set glaa=23322 where gldoc=506594.0 and glicu=694337

Note:- JD Edwards not recomending to use SQL, use this method with your own risk. Before doing above Make backup of F0911 & F0902.
 
 

Tuesday, October 19, 2010

Create HTML5 Website and Page Templates for Visual Studio 2010

http://blog.reybango.com/2010/09/21/how-to-create-html5-website-and-page-templates-for-visual-studio-2010/


 


How to fix Double sales update in JD Edwards /Enterpriseone

This is I think a common problem in JD Edwards , if user is doing sales update, sometime they run wide open sales update, i mean with wrong data selection, If anyone is doing sale update without next status is equal to 620, then this will update your already updated orders. I fix double sales update following way:-
1. If there are 50/100 sales order then I will ask user to enter credit sales order with same quantity and do sales update.
2. if user by mistake updated more than 1000 orders also if they already posted IB and G batch(In our setup we hit cardex at the time of sales update )
a.Take backup F03b11,F4111,F0911,F0902,F4211,F41021
b. If the batches for the user did double sales update from P0011 screen.
c. Go at F03B11, and find all the sales order using batch no.(select rpdoc,rpsdoc,* from proddta.f03b11 where rpicu=111111)
d. Go at F4211 and update next status,last status.
e. delete that batch from F03b11.
f. find all the account # from F0911, select distinct glaid from proddta.f0911 where glicu=111111
g. delete batch from f0911.
h. use Repost program R099102 and update all the affected account.

Note: use this process if you are confident, with your own risk. 

 

JD Edwards order reversed by my user id

While receiving order #281147 JD Edwards kicked me out, and now its locked, I mean reversed by my user id.
Please unlock this order so I am able to continue receiving it
 
Solution: any order saying reserved by particular user , Type P00095 in fast path and find & delete that order.
 
 

JD Edwards EnterpriseOne 9.0 Create business view

Monday, October 18, 2010

JD Edwards Write report with level break or summary report

JD Edwards EnterpriseOne Create omw Project

Data import by dts using sql-server 2000 to excel 2007

Data import by dts using sql-server 2000 to excel 2007
 
 
if you have Office 2007 installed on the system, you must use "Microsoft Excel Driver (*.xls, *.xlsx, *xlsm, *.xlsb)" for the import.
If you do NOT have Office 2007, then download the Office 12 data provider at: http://www.microsoft.com/downloads/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891
 
 

JD Edwards & Citrix Configuring Automatic Client Reconnection

Configuring Automatic Client Reconnection
 

citrix connection jd edwards connection broken

Citrix connection application connection broken
 

MYSQL Error: What find_config_file/local

What find_config_file/local

Check if  can be accessed

Operation failed: File  doesn't exist

 

sOLUTION: http://bugs.mysql.com/bug.php?id=56911

Friday, October 15, 2010

Create Business View in JD Edwards EnterpriseOne

Create Business View in JD Edwards EnterpriseOne

Wednesday, October 13, 2010

Mysql create user and Grant permission

CREATE USER 'visli'@'localhost' IDENTIFIED BY '123456';

GRANT SELECT,INSERT,UPDATE,DELETE ON *.* TO 'visli'@'localhost';
GRANT ALL ON *.* TO 'visli'@'localhost';

Access database The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.

The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.
How to switch between the 32-bit versions of ASP.NET 1.1 and the 64-bit version of ASP.NET 2.0 on a 64-bit version of Windows..
 
 

Monday, October 11, 2010

Friday, October 8, 2010

Error: Posting Edit Code Does Not Allow JD Edwards EnterpriseOne

If you are getting following error it means your account master defined as not allowing posting in that particular account, you have to either change that account no or type in fast path p0901 and make this account to allow posting, by changing Posting Edit field.

 
Subject       : Error: Posting Edit Code Does Not Allow
CAUSE . . . .  The posting edit code does not allow transactions to be posted
               to this account. Valid codes include:
     Blank - all postings are allowed.
       'N' - the Account or Business Unit does not allow posting.
       'B' - only budgets may be entered for an account.
'S' or 'L' - a subledger and type must be entered for all transactions.
       'X' - a subledger and type are not allowed for any transactions.
       'I' - the account is inactive, posting is not allowed.
       'U' - units are required for all transactions.
       'M' - only machine generated transactions are allowed for this account.
The posting edit code is defined for business units in the Business Unit Master
file (F0006) using Single Business Unit Revisions or Job Master Setup.  The
posting edit is defined for accounts in the Account Master file (F0901)
using G/L Account Structure programs and Job Cost Basic/Speed Budget Setup.

Thursday, October 7, 2010

JD Edwards EnterpriseOne Business Function To convert Number to Subledger Format

 Business Function To convert Number to Subledger Format
Function Name: FormatSubledger
BF Prog.ID : B0000021
Just Pass the parameter for Ledger Type and subledger no.

Wednesday, October 6, 2010

How to Associate Description In JD Edwards EnterpriseOne Application?

Associate Description means you dont have to fetch from any table , example for search type in address book you can add search type description without any fetch, you have click on TextBox-> click at EDIT->after that Associate description.

IB Batch Error: Tax Area Invalid

IB batch in error and you are getting this error message in workcenter:

Subject : Error: Tax Area Invalid

CAUSE . . . . The tax area does not exist in the Tax Area Master

file (F4008). A tax area having an effective date prior

to the tax point date (service date) must exist in the

Tax Area file.

RESOLUTION. . Change the service date if applicable or change the tax area to

a valid tax area.

NOTE: The service date is not applicable in certain

circumstances. For example; Supplier Master, Customer

Master and Business Unit Revisions.

 

Solution:- Go go F03B11 or customer ledger entry P03b2002 and see the tax area and after that type P4008 in fast path and see the value there , must me less than todays, change this date as today's date and post again.

 

mvc The resource cannot be found.

mvc The resource cannot be found.

Monday, October 4, 2010

Displaying a Table of Database Data MVC2

Displaying a Table of Database Data: The Official Microsoft ASP.NET Site

Error: Extended Price invalid , JD Edwards

Getting error when try to receive a Purchase Order when changing exchange rate :-  Extended Price invalid ,
 
Solution:- change F4301 and F4311 PHCRR /PDCRR field with correct exchange rate.

 

The type or namespace name 'MovieDataContext' could not be found (are you missing a using directive or an assembly reference.

The type or namespace name 'MovieDataContext' could not be found (are you missing a using directive or an assembly reference?
change like following
 

var dataContext = new tstdataDataContext();

var movies = from m in dataContext.yourlinqtosql

select m;

return View(movies);

Linq to sql classes missing Express 2010 MVC2 Application

You must be selected Web, instead of web click on Visual C# and try to find, you will see in list.

ASP.NET Security Fix Now on Windows Update

http://weblogs.asp.net/scottgu/archive/2010/09/30/asp-net-security-fix-now-on-windows-update.aspx

Friday, October 1, 2010

Gridview Delete Button Right side & colorful

 
<
Columns>

<asp:BoundField DataField="IAID" HeaderText="id"

SortExpression="IAID" Visible="false"/>

<asp:BoundField DataField="IACOMP" HeaderText="Company"

SortExpression="IACOMP" />

<asp:BoundField DataField="IAMEDQTY1" HeaderText="Media1"

SortExpression="IAMEDQTY1" />

<asp:BoundField DataField="IAMEDQTY2" HeaderText="Media3"

SortExpression="IAMEDQTY2" />

<asp:BoundField DataField="IABOXQTY" HeaderText="Box Qty"

SortExpression="IABOXQTY" />

<asp:BoundField DataField="IAGELQTY" HeaderText="Gel Packs"

SortExpression="IAGELQTY" />

<asp:BoundField DataField="IACRYQTY" HeaderText="Cryosettes"

SortExpression="IACRYQTY" />

<asp:BoundField DataField="IADATETM" HeaderText="Date"

SortExpression="IADATETM" />

<asp:TemplateField>

<ItemTemplate>

<asp:Button ID="Button1" CommandName="Delete" runat="server" Text="Delete" />

</ItemTemplate>

</asp:TemplateField>

</Columns>